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

Question

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!

Merge.yxmd

DataNath · Accepted Answer

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