Fuzzy match

[sriniprad08]

Hi Team,

Hope you are well. I need help.

I have two files A and  B. The workflow has to do a fuzzy match between Ctr column in File A and File B and return the required output.

Please find attached and let me know how to go about it.

Thanks,

Sri

[Raj]

@sriniprad08 why you are not joining the data as both the columns are identical

[sriniprad08]

thanks for the reply. I tried to join in my original data and found that there are few Ctr which are present in both but didnt appear in the final output. So i thought fuzzy logic would help.

[Raj]

@sriniprad08 Use data cleansing to remove impurities and then try 
this will work