Lookup enrichment , Masking and unmasking

Question

hello,

I’m working on a dummy task.
I have a lookup of 3 fields one of them is “card number” and it’s masked as shown in the attachment.

I then have sample files that I need to enrich them with this lookup using the “card number” field as the joining field.

The sample files have the “card number” field but umasked with normal digits.

How can i enrich the sample files with the lookup when i don’t know the masking expression of the lookup field ?

Can anyone help ?
attached is the lookup file

Page 1 / 1

You can use the "Regex" match mode in the Lookup Function to enrich the data with the Country and Operator fields.

Here's an example with the first three rows:

Reply

Brendan Dalpe · Accepted Answer

You can use the "Regex" match mode in the Lookup Function to enrich the data with the Country and Operator fields.Here's an example with the first three rows:

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded