Exporting duplicates in Separate file.

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.

invo_extract_dummy.xlsx

Fuzzy Match

Data Investigation

Accepted answers

All comments

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-for-similarity/td-p/63864

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

Please see bleow:

Attached the wotkflow,

Hope this helps,

Regards

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

Cheers,

Sri

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703