Hello everyone, I am stuck in between a workflow. After joining data using Union tool, what I am getting is Tile_NumCountError AError BError CError DError E22 DDD 22 TC code 22 H status 22 F status72 F status22Company 72 DDD I want to get all the errors for one Tile_Num from all the columns in one row, like this- Tile_NumCountError AError BError CError DError E22CompanyDDDH statusTC codeF status72 DDD F status Can someone please help?

Join data from multiple columns to one row

Hello everyone,

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

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

Can someone please help?

Workflow

Join

Hi @Pramod91 , try this.

Thanks.

I have created a workflow for you:

The output:

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

Good Luck!

Hey @Pramod91

You can achieve this with the summarize tool:

Hi @Pramod91 , try this.

Thanks.

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!

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

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 😀