How to compare two files and extract the unique records in a 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. Does anyone know how to compare MS-Excel files and extract the unique records in a CSV file using Alteryx Designer? Thanks!
Solved! Go to Solution.
- Labels:
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mkeiko - assuming you have a common field between the two files, you can use the join tool and pass the L and R anchors to an output
Without knowing what your data looks like:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Bren!
My MS-Excel Spreadsheets have different sizes and columns, but both have "telephone number" column in common.
Input Files:
#1 File has 13 columns (593,175 records)
#2 File has 8 columns (450,241 records)
I would like to create an output file with the unique records from #1 File.
Could you help me?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mkeiko - see attached. Is this what you need?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Bren! That´s it! Thanks for help!
