New User Struggling with splitting data

[jay1994a]

Hi all,

Any help would be much appreciated. I have a json file which i am struggling to break out. I have used json parse and have had no luck in getting the output I want as i think this might be some kind of nesting issue.

[RolandSchubert · Accepted solution]

Hi,

it should be possible to split to JSON_NAME and JSON_VALUE using the JSON Parse tool,
then use a formula tool to extract the ID from each field, and Crosstab tool to create columns.

A sample workflow is attached, hope, this is helpful.