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

[mkeiko]

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

[Bren_Spill]

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

[mkeiko]

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 · Accepted solution]

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

[mkeiko]

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