How to merge 2 rows with different fields of different files in only one row

[maxtla]

Hi,

I have 2 different files with a common field (ID). These 2 files has different fields, but I want to merge them in only one file with one row per ID.

How can I do this? I union tool but the result are 2 rows and I need only one with all fields.

Then I tried to transpose and then cross tab with the unique for avoiding double figures, but I noticed that there are still removing rows with data that I need...

Thanks for your help!

[DataNath · Accepted solution]

@maxtla instead of a Union tool which stacks data on top of each other, you'll want to use a Join tool to place matching rows side-by-side. In this case, you'll want your Join condition to be the common field i.e. [Action ID]:

[maxtla]

Thanks for your solution. sometimes I cannot see further...thanks