Join data from multiple columns to one row

[Pramod91]

Hello everyone,

I am stuck in between a workflow. After joining data using Union tool, what I am getting is 

Tile_Num	Count	Error A	Error B	Error C	Error D	Error E
2	2		DDD
2	2				TC code
2	2			H status
2	2					F status
7	2					F status
2	2	Company
7	2		DDD

I want to get all the errors for one Tile_Num from all the columns in one row, like this-

Tile_Num	Count	Error A	Error B	Error C	Error D	Error E
2	2	Company	DDD	H status	TC code	F status
7	2		DDD			F status

Can someone please help?

[Emil_Kos]

Hi @Pramod91,

I have created a workflow for you:

The output:

If this is something helpful for you please mark it as a solution!

Good Luck!

[TheOC]

Hey @Pramod91 

You can achieve this with the summarize tool:

[grazitti_sapna · Accepted solution]

Hi @Pramod91 , try this.

Thanks.

[Pramod91]

Thanks all of you for the help! All three solutions worked for me.

But the one by @grazitti_sapna was the simplest to use. Thank you Sapna!

[grazitti_sapna]

@Pramod91 , Welcome and thanks for marking my post as a solution.

[Emil_Kos]

and the winner is @grazitti_sapna 

[atcodedog05]

Hi @TheOC 

Even yours would have the simplest solution if you had renamed your columns in Summarize tool. 

Currently it has prefix Max_ which puts it apart from the exact expected solution.

Cheers and Happy Analyzing 😀

[TheOC]

hi @atcodedog05 

Very correct - my mistake in missing that.

Fixed the workflow attached, might be helpful for you @Pramod91 

or at very least, just another way of creating the solution!