In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to compare two files and extract the unique records in a file?

mkeiko
6 - Meteoroid

Hi. Does anyone know how to compare MS-Excel files and extract the unique records in a CSV file using Alteryx Designer? Thanks!

4 REPLIES 4
Bren_Spill
12 - Quasar
12 - Quasar

@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:

 

image.png

mkeiko
6 - Meteoroid

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.

Bren_Spill
12 - Quasar
12 - Quasar

@mkeiko - see attached. Is this what you need?

mkeiko
6 - Meteoroid

Hi Bren! That´s it! Thanks for help! 

Labels
Top Solution Authors