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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
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.
Highlighted
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

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