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