Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Join of two exact same files.

aishwaryapan
5 - Atom

Hi all, 

I need to merge two files which has exact same  coloumns in both but the datas are different. After using union tool it's making few duplicates. So I think join us the only option. But as there is no such unique field,I am confused what to do..

1 REPLY 1
binuacs
21 - Polaris

@aishwaryapan If you want to merge the two files use the union tool and remove the duplicate records using the unique tool

 

binuacs_0-1680859731016.png

 

Labels
Top Solution Authors