So I am pulling data of an API using the download tool and then JSON parse to get the data.
What I have is
JSON Name json value
sno.0.id 1
sno.0.name robert
sno.0.desc employee
What i need is
ID Name Desc
1 Robert employee
so i have 20 different entries with value. I need to sort the data with the appropriate column headers and values. I was trying the text to column tool but something was not right.
Appreciate if someone can help ?
Solved! Go to Solution.
Hi @SouravKayal
The best way to approach this is generally to use a Text to Columns tool on the JSON Name field to split it on the period character. Then you will want to use a Crosstab tool where you group by JSON Name 2 (new column created), use JSON Name 3 as the Column Headers, and JSON Value as the values