Make a list from multiple documents
I have a need to create a single list from multiple documents. Here is an example of some JSON:
[
{
color: “test1”,
value: “111”
},
{
color: “test2”,
value: “222”
},
{
color: “t...
Forum Discussion
Here’s a full example of what @tstack described.
First group all the documents into a single document.
Then select all the values into a single list using a mapper. Here is an expression that uses the jsonPath function to select all the value from the document.
jsonPath($, '$.group[*].value')
Here is a copy of the pipeline if you want to experiment with it further.
groupby_2018_10_16.slp (5.6 KB)
