Concatenate multiple values for the same key

R00

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_MultipleValues.xlsx

Best Practices

Accepted answers

Shaaz

Attached is the .yxmd file, please use this workflow

Concat_Multiple_Values.yxmd

AmitBelagali

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

Solution.PNG

All comments

Shaaz

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

Concat_values_Multiple.yxzp

R00

Hey shaaz,

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

Thank you

AmitBelagali

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

Solution.PNG

AmitBelagali

Hi R00,

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

Thanks,

Amit Belagali

R00

That's perfect Amit! thank you so much

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703