Build JSON grouped by ID

[HDA_Hans]

Hi, I am trying to build a JSON file with a bit of complexity included. It sounds so easy to me but I can't work it out somehow. I would like to group by an id the JSON.

If you look at the following table:

If would like to group it by the id and have an output like this:

Has anyone an idea how to solve this?

Demo data is included here in the attached "example_alteryx.csv.

I have also converted it on https://www.convertcsv.com/csv-to-json.htm and it converted exactly as I wanted it using the "CSV to Keyed JSON". See the file convertcsv(1).json.txt.

Any help would be greatly appreciated.

Thanks,

Hans

[atcodedog05 · Accepted solution]

Hi @HDA_Hans 

Default JSON Build tool doesnt give your expected output. Here is how you can do it.

Workflow:

Hope this helps : )

[HDA_Hans]

Hi @atcodedog5 fantastic, thanks for your quick reply and this is indeed a typical hidden gem in Alteryx. I never new you could specify how to concatenate in the summarize tool. Thanks so much!

[atcodedog05]

Happy to help : ) @HDA_Hans 

Cheers and have a nice day!