Join of two exact same files.

[aishwaryapan]

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..

[binu_acs · Accepted solution]

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