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

Concatenate multiple values for the same key

R00
5 - 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!

8 REPLIES 8
Shaaz
9 - Comet

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

R00
5 - Atom

Hey shaaz,

 

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

 

Thank you

Shaaz
9 - Comet
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.
Shaaz
9 - Comet

Attached is the .yxmd file, please use this workflow

AmitBelagali
8 - 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

AmitBelagali
8 - Asteroid

Hi R00,

 

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

 

Thanks,

Amit Belagali

R00
5 - Atom

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

R00
5 - Atom

Thank you so much shaaz!! :)

Labels