community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Parse Shopify Product JSON Data

Asteroid

I am trying to parse shopify product json 

The expected output would be a product table with multiple products and if a product has more than one variant there should be more than one records against that product .

 

Here is the attached file related to work what i have done soo far .

Bolide

Hi @tjamal1 ,

Extracted main  title and variant  title  using  attached wf  . 

Let me know if this expected output .

Asteroid

Each product should be in a different row for example 

 

product ID Title htmlvariantId 
1abcabc1
1abcabc2
2xyzxyz1
2xyzxyz

2

 

also note that if a product has more than 1 variant it should have more than 1 record

Labels