community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Concatenate multiple values for the same key

Atom

Hey Alteryx community,

 

I'm attaching a small excel file cause I'm having a problem posting a table on here.

 

The original data set and the desired outcome.

Please assist, I tried cross tab and multi row but I don't seem to be able to achieve this..

Any help would be much appreciated!

Thank you!

Alteryx Partner

Please refer the attached workflow. This should solve your issue.

Atom

Hey shaaz,

 

I can't seem to be able to open that package..

 

Thank you

Alteryx Partner
Please open it with latest version of Alteryx i.e, v11.3.

If still you are not able to, please share the screenshot of issue that you are facing.
Alteryx Partner

Attached is the .yxmd file, please use this workflow

Asteroid

Hi R00,

 

Please add a summarize tool and add ID as GroupBy, Description as Concat and Price as Sum. attached is the screenshot for your reference. Do let me know if this works for you. 

 

Thanks, 

Amit Belagali

Highlighted
Asteroid

Hi R00,

 

Were you able to get the desired output? If not, do let me know.

 

Thanks,

Amit Belagali

Atom

That's perfect Amit! thank you so much :)

Atom

Thank you so much shaaz!! :)

Labels