Join of two exact same files.

Question

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 Answer

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