API (json file)

[domax37]

Hi , 

i'm a newby with Alteryx. I need to use this API https://sheetlabs.com/DA/winequality (containing information about different wines and caracteristics) and import it in Alteryx and make it readable to start an analysis . I think i'm doing something wrong along the way cause I'm unable to extract the information correctly .

Can you help me to understand what i'm doing wrong ? ( I have attached my workflow) 

thanks a lot 

[Sebastiaandb · Accepted solution]

@domax37 

Here you go!

The first number in the JSON_Name field is related to the record_id. Therefore, you need to separate the record_id and fieldname from that column before using the crosstab tool :-). 

Just let me know if this works out for you!

Greetings,

Seb

[domax37]

thank you so much! very appreciated 

Catherine

[Sebastiaandb]

@domax37 Glad to help out! 😄

Greetings,

Seb