Data Transformation

[John98]

Dear all,

I have an json file format contains data of orders from a cashier system of 3 restaurants and I'm looking to parse these orders

Any idea on how can I do that? Since it's the first time for me to work with data from json format. I used to work with excel format data.

Your help will be much appreciated.

Thanks in advance for your kind support. 

[VictorLeonis]

@John98I didn't find the JSON. Can you confirm if you attached it?

[John98]

I have modified the post and added the link of a sample of JSON file  

[VictorLeonis]

@John98 

Thanks for attaching the JSON.
I've created a job to parse JSON. I separated into 2 tables, the product table and the order table. After parse JSON, data are structured, and is easy for you to make calculates or operations that you need.

Check the workflow attached and let me know if it helps you or if you need something more.

[John98]

Thanks for helping ! Much appreciated !

[VictorLeonis · Accepted solution]

@John98  Sorry for that. We can have more than one order for the same ID. I was concatenating for this reason when the ID had more than one order appear values like 1,1.
I split it and create a new ID as the picture below.

Let me know if you have any question 

[John98]

Thank you !