ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

API JSON Output format to table format

harinder
6 - Meteoroid

Hi 

I am trying to convert API JSON Output format to table format.

 

From:

JSON Name JSON ValueString
data.0.Name A1
data.0.Age B1
data.0.Skills C1
data.1.Name A2
data.1.Age B2
data.1.Skills C2
data.2.Name A3
data.2.Age B3
data.2.Skills C3

 

 

Required columns:

RowNo Name Age Skills
0 A1 B1 C1
1 A2 B2 C2
2 A3 B3 C3

Appreciate your advise.

Thanks

Harinder

mceleavey
14 - Magnetar

Hi @harinder ,

 

Hello Regex my old friend....

 

mceleavey_0-1616516900289.png

mceleavey_1-1616516914845.png

 

Hope this helps.

 

M.

Luke_C
12 - Quasar

@harinder 

 

You can parse the json field then crosstab the data:

Luke_C_0-1616516971644.png

 

harinder
6 - Meteoroid

Thank you 🙂

messi007
13 - Pulsar

@harinder,

 

Please see below:

 

messi007_0-1616517216835.png

 

If this solve the need please make it as solved it will help others,

 

Attached the workflow,

Regards,

Labels