List of multiple values in same field by reference key

[slckkrky]

Hi

I have a list of cities per id and each id can have multiple city records. I would like to bring all cities per id in same field as shown in the picture below. There is an easy function in other tools called "OVER". IS there something similar in Alteryx?

Thank you

Sel

[afv2688]

Hello @slckkrky ,

For that you need to use the 'Summarize tool'. Just group by id and then on the city parameter select the function concatenate.

Cheers

[gtejoram · Accepted solution]

Hi

This can be generated using Cross tab tool as shown in the snapshot