Hi Team, Can you help with my scenario. I need to mask a flat file and in one of the column there could be duplicate values and after masking they want to keep the same masked values for both the records. But I do not have an unique identifier for each records. Any help much appreciated.
1st record - A,Greg,EOF
2nd record - B,Joe,EOF
3rd record - C,Greg,EOF
1st record - A,JOHN,EOF
2nd record - B,JACK,EOF
3rd record - C,JOHN,EOF
You can use HASHLOV to mask the column having duplicate values. You need to have one seedlist for this. This technique will mask duplicate values as duplicate.
You can get more about HASHLOV using below link.
Thanks Raju for the response.
I'm familiar with HASHLOV and question was which field to hash on as there was no Identifier. Anyway I will try with hashing on the name itself, but the names has something appended to it like "Greg - A111".