Combing an Union on common dimension

[SR]

Hi all,

I am connecting 3 outputs to an union based on a common dimension. This is the output i am getting from the union . the 3 outputs to the union are Org and Col1 or Org and Col2 or Org Col 3.

ORG	Col 1	Col 2	Col 3
ABC	10
XYZ	5
ABC		22
XYZ		2
ABC			45
XYZ			32

Is there a way i can get the output in this formart

ORG	Col 1	Col 2	Col 3
ABC	10	22	45
XYZ	5	2	32

Thanks for your help

SR

[Ahmed_AlZabidi · Accepted solution]

Hello s49ers,

You can do it by "Join Multiple"

The solution is in the attached file

[mbarone]

The join multiple tool will do it in one fell swoop, but if for whatever reason you have to use the union tool, then you can put a summarize tool after it.  You'd group on the ORG field and sum the other fields.

[SR]

Thank so much for a quick reply. appreciate the help.