Lookup enrichment , Masking and unmasking
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
Best 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:
0
Answers
-
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:
0