How Convert or Flatten a Nested JSON

[carltonp]

Hello Community,

I have been exploring Alteryx now for about 3 months. I'm very excited with its possibilities.

Can somoene let me know how Alteryx deals with Nested JSONs? 

For example I'm able to flatten the attached Nested JSON to CSV by simply dragging the Json to any online JSON to CSV converter.

Is it possible to use of the Atleryx tools to do something similar?

So, basically, I would like to convert or flatten the attached JSON to CSV with Alteryx

Thanks

[carltonp]

Thanks Felipe

[Felipe_Ribeir0 · Accepted solution]

Hi @carltonp 

Could you please see if it makes sense? 

[carltonp]

Hi Felipe,

Sorry for the delayed response. It was getting late for me here in London.

I'm going to check out your workflow now.

[carltonp]

OMG! Felipe, this is amazing. 

Thank you so much

[carltonp]

Hi Felipe,

I just need to carry out a few checks, but as it stands, it looks amazing.

As soon as I finished doing a few more checks I will mark the solution as accepted.