How Convert or Flatten a Nested JSON

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

Datasets

Connectors

Accepted answers

Could you please see if it makes sense?

How Convert or Flatten a Nested JSON.yxzp

All comments

Hi @carltonp Do you have a sample output you could share? Have you tried the JSON Parse tool? Typically the first step to flattening json is using a JSON parse tool followed by a crosstab tool.

Do you have a sample of what the final data would look like.

Alteryx provides a JSON parse tool, however depending on the structure of your data you may need to do some additional data massaging. In my experience its typically a combination of the record id, transpose/cross tab, and text to columns.

Yes, it is possible. Take a look at the attached workflow, you usually can do it for any JSON using these same steps.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

How Convert or Flatten a Nested JSON.yxzp

Hi Luke,

Thanks for reaching out.

Please find attached a sample output.

Regards

generalcombined.csv

Hi Felipe,

That's great. I can't wait to test it on my json.

In the meantime, I have sent a sample output

Hi Feliple,

The workflow is missing the companyId

added the field.

How Convert or Flatten a Nested JSON.yxzp

Hi Felipe

Thanks for reaching out again. However, there is something strange going on with your output.

If you look at my output, there should only be 3 rows with the following company Ids

00041424

00053417

00048796

But you only have output for 00041424. Or am looking at this incorrectly? How would this look if exported to a CSV file.

Take a look at my output

generalcombined.csv

@carltonp you are right, something got missing when it was inputed. Give me some minutes, gonna try to figure out.

Thanks Felipe

Could you please see if it makes sense?

How Convert or Flatten a Nested JSON.yxzp

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.

OMG! Felipe, this is amazing.

Thank you so much

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.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703