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

example_alteryx.csv

convertcsv (1).json.txt

atcodedog05

Hi @HDA_Hans 

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

Workflow:

Hope this helps : )

JSon Build.yxmd