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 

[MichalM]

@tjamal1 

This shouldn't be a problem in Alteryx but the method will depend on data structure.

Could you please send a sample which contains data for multiple products (at least 2)?

[tjamal1]

Here is the Json with 3 products 

[benakesh]

This  workflow  reads json ( code page utf-8)  using  regular input tool  and  cross tab puts data in table format .

[tjamal1]

Is there anyway you can produce 2 records per product 

So that for each product it should be like 

ProductID Language 

1                  EN

1                   FR

and other columns will remain same for this product for both EN and FR  

[benakesh · Accepted solution]

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

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

[tjamal1]

Thanks For the solution , it helped me understood JSON Structure