Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join data from multiple columns to one row

Pramod91
8 - Asteroid

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 E
22 DDD   
22   TC code 
22  H status  
22    F status
72    F status
22Company    
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 E
22CompanyDDDH statusTC codeF status
72 DDD  F status

 

Can someone please help?

8 REPLIES 8
Emil_Kos
17 - Castor
17 - Castor

Hi @Pramod91,

 

I have created a workflow for you:

 

Emil_Kos_0-1603267895989.png

 

 

The output:

 

Emil_Kos_1-1603267911280.png

 

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

 

Good Luck!

TheOC
15 - Aurora
15 - Aurora

Hey @Pramod91 

You can achieve this with the summarize tool:

TheOC_1-1603268363222.png

 


Bulien
grazitti_sapna
17 - Castor

Hi @Pramod91 , try this.

grazitti_sapna_0-1603269294566.png

 

Thanks.

Sapna Gupta
Pramod91
8 - Asteroid

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
17 - Castor

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

Sapna Gupta
Emil_Kos
17 - Castor
17 - Castor

and the winner is @grazitti_sapna 

 

Emil_Kos_0-1603273635884.gif

 

atcodedog05
22 - Nova
22 - Nova

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
15 - Aurora
15 - Aurora

hi @atcodedog05 

Very correct - my mistake in missing that.

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

TheOC_0-1603276806634.png

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


Bulien
Labels