Exporting duplicates in Separate file.

[sriniprad08]

Hi Team,

I have two excel file and both need to compare for the similarity and if anything is similar/duplicate should be exported in the separate file. It's also possible that certain characters in the field appear similar but few characters don't match. Ideally the workflow has to pick up the closest match .

Thank you for the help.

[mhey01]

Hey @sriniprad08 

I believe you could achieve this using the 'Fuzzy Match' tool but I'm not particularly confident in how to use it.

Here is a link to a similar issue where @DultonM has provided a solution.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Comparing-Records-between-two-columns-... 

[messi007]

@sriniprad08,

You can do a join on all columns then generate the output

Please see bleow:

Attached the wotkflow,

Hope this helps,

Regards

[sriniprad08]

Hi @mhey01 ,

Thank you for sharing this. I will go through it.

Cheers,

Sri

[sriniprad08]

Hi @messi007 ,

Thank you for sharing . Unfortunately i have older version i couldnt import it.

[messi007]

@sriniprad08,

please try this,

then update 2020.4 with your version:

Best Regards,

[sriniprad08]

Hi @messi007  Thank you. I tried exporting in notepad++ to edit. But its giving weird format. Can you please let me know your thoughts,

[clmc9601]

Hi @sriniprad08,

I edited the file as mentioned above to be compatible with 2019.2. Hopefully this works for your version!