Alteryx API connect

[SouravKayal]

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 ?

[BrandonB · Accepted 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