Nested Json

tjamal1

I am trying to parse a json related to product which have some json arrays

like productname in 2 different languages and also product category in 2 different languages

is there anyway  can i parse my json and then convert into table format so that 

each product can have have 2 records , each records have some common column values and some are different 

for example 

product id  language 

1                 EN

1                    FR

I am attaching my JSON 

Nested Json.txt

benakesh

This  helped  me understand the structure  :   https://jsonformatter.curiousconcept.com/  .  

Individual arrays within object can be separated  . They are  processed  and combined  together.   

json2.yxmd