Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Fuzzy match

sriniprad08
11 - Bolide

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

 

 

 

3 REPLIES 3
Raj
15 - Aurora

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

sriniprad08
11 - Bolide

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
15 - Aurora

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

Labels