Data Transformation

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.

Workflow

Parse

Help

Udacity

Accepted answers

VictorLeonis

@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

All comments

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

Let me know if you have any question

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703