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?
Solved! Go to Solution.
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!
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.
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 😀
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!