JSON Output with Inconsistent Values

[toral]

I have json response that contains inconsistent name/value pairs. For eg, sometimes, city will be a part of the response and sometime it won't. I am transforming this output to csv and the csv is also inconsistent as sometimes it will have 5 columns and sometimes 4.

How to handle this kind of inconsistent json response within Alteryx so that the csv output has same # of fields always, with null or static values for the fields missing in the json response. 

[gawa · Accepted solution]

hi @toral In order to fix output schema, you can append "0 row" data having all possible fields to the output from JSON parse.

By doing so, all of fields can maintain.
Please note that this approach works only when you already know what fields can be available in JSON response. 

[toral]

Thanks @gawa. That was a smooth approach and works well for me.