Create Array from Flattened Docs

Using Json generator I used this array of flattened docs:

from there I sort on product-id using sort snap,

then I groupBy product-id into a field called ‘group’:

Finally in the mapper I use this expression:

which generates an array of docs where each doc has ‘product-id’: [array of variants]:

If you need the output to look EXACTLY like you described you can use this expression instead of the one above: { “product-id” : $group[0][‘product-id’],“variants” :$group.reduce((accum, curval) => accum.concat([curval[‘variant’]]), )}

which will generate output exactly as you described: [{“product-id”:“1001”,“variants”:[“777101”,“777100”]},{“product-id”:“1002”,“variants”:[“777102”,“777103”,“777104”,“777105”]}]

Let me know if this answers your problem.

Hi, I finally got it! Played around more with my expression and finally got what I needed. Sharing my solution:

{ “@product-id” : jsonPath($, “$group[0][‘@product-id’]”), “variations” : { “variants” : $group.reduce((accum, curval) => accum.concat([curval[‘variants’]]), ) } }

I am unable to see your pipeline or input data in those images. can you give a clear example of the input data and the desired output data for the given input?

Oh, this is AWESOME! While the scenario I created isn’t exactly what I needed (I was trying to keep it simple), the solution you provided should be enough for me to run with. I’m gonna try it out now. Thanks so much for the assist!

Thanks so much again for your help. I’m pretty new to using both JSON and Javascript, so I’m learning quite q bit here. I’m so much closer to where I need to be.

Ultimately, I need something that looks like this:

Catalog
Product : {
@product-id : 1002,
variations : {
variants : [{
variant @product-id : 888
variant @product-id : 777
variant @product-id : 666
}]
}
}

Output from my GroupBy:

Expression Builder Expression and Map:

My actual results. Rather than the “variant” element repeating, it seems to be looping back up to “variants.”

I tried using a JSON Path Epresssion Tester that I found on Google, but it wasn’t much help for me. Most likely due to my inexperience. Any guidance would be greatly appreciated.

Alex

okay, i’ll try that out.

Thought I’d let you know how I was able to remove duplicate entries from my array. I basically was using this reduce method to create my array in a mapper expression.

$product.reduce((accum, curval) => accum.concat([curval[‘variation-attribute-value’][0]]), )

To remove any duplicate entries while the array was being built, I added a filter method to it, like so:

$product.reduce((accum, curval) => accum.concat([curval[‘variation-attribute-value’][0]]), ).filter((item, pos, a) => a.indexOf(item) == pos)

I pretty much just copy/pasted this filter method from the Snaplogic help documentation.

Thanks everyone for your help. I really appreciate all the support.