Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Join data from multiple columns to one row

Highlighted
7 - Meteor

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?

Highlighted
13 - Pulsar

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!

Highlighted
Alteryx Certified Partner

Hey @Pramod91 

You can achieve this with the summarize tool:

TheOC_1-1603268363222.png

 

Highlighted
Alteryx Partner
Alteryx Partner

Hi @Pramod91 , try this.

grazitti_sapna_0-1603269294566.png

 

Thanks.

Sapna Gupta
Highlighted
7 - Meteor

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!

Highlighted
Alteryx Partner
Alteryx Partner

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

Sapna Gupta
Highlighted
13 - Pulsar

and the winner is @grazitti_sapna 

 

Emil_Kos_0-1603273635884.gif

 

Highlighted
17 - Castor

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 😀

Highlighted
Alteryx Certified Partner

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!

Labels