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!
Solved! Go to 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]:
Thanks for your solution. sometimes I cannot see further...thanks