Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Nested Json

tjamal1
8 - Asteroid

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 

6 REPLIES 6
MichalM
Alteryx
Alteryx

@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
8 - Asteroid

Here is the Json with 3 products 

benakesh
12 - Quasar

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

 

clipboard_image_0.png

tjamal1
8 - Asteroid

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
12 - Quasar

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

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

 

tjamal1
8 - Asteroid

Thanks For the solution , it helped me understood JSON Structure 

Labels