Group by to one object

Designing Pipelines
#1

Hi Everyone,

I have a group by field that’s working as expected. What I need to do next is iterate through the rows combing them into one document. For example.

Customer
1
2
3

Orders
Customer Order Item
1 1 Dog
2 2 Cat
1 3 Fish

Customer Orders
1 Dog
3 Fish

#2

Hi Chris,

Can you please post the input JSON and the desired output JSON, using the Preformatted Text option (icon looks like </>) to paste each JSON block? That would make it much easier to understand exactly what you’re trying to do.