Forum Discussion

alex_panganiban's avatar
alex_panganiban
Contributor
7 years ago

Create Array from Flattened Docs

I could really use some help. I have flattened documents and for each distinct product-id value, I wish to create an array list of the variants that belong in the product-id’s family. My desired r...
alex_panganiban's avatar
alex_panganiban
Contributor
7 years ago

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