Exporting duplicates in Separate file.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Data Investigation
- Fuzzy Match
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can do a join on all columns then generate the output
Please see bleow:
Attached the wotkflow,
Hope this helps,
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @messi007 Thank you. I tried exporting in notepad++ to edit. But its giving weird format. Can you please let me know your thoughts,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sriniprad08,
I edited the file as mentioned above to be compatible with 2019.2. Hopefully this works for your version!