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. ORGCol 1Col 2Col 3ABC10 XYZ5 ABC 22 XYZ 2 ABC 45XYZ 32 Is there a way i can get the output in this formart ORGCol 1Col 2Col 3ABC102245XYZ5232 Thanks for your help SR

Combing an Union on common dimension

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

Developer Tools

Join

Accepted answers

Ahmed_AlZabidi

Hello s49ers,

You can do it by "Join Multiple"

The solution is in the attached file

Join Multiple.yxmd

All comments

Ahmed_AlZabidi

Hello s49ers,

You can do it by "Join Multiple"

The solution is in the attached file

Join Multiple.yxmd

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.

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335