Merge multiple documents to an array in ultra pipeline

[thilkip]

We need to merge multiple documents to single array and looking for help. Since it is ultra task, we are running out of options…

Input data:

[
{“Record”: “1”},
{“Record”: “2”},
{“Record”: “5”},
{“Record”: “4”},
{“Record”: “6”}
]

Expected Output:
[ “response”: [{“Record”: “1”}, {“Record”: “2”}, {“Record”: “5”}, {“Record”: “4”}, {“Record”: “6”}]
]

[thilkip]

Thanks. but please see below, 40 documents went in and 0 out. if we put the write inside the while loop, it will write 40 documents in this case but we need the 40th document as the final result. if there is a way to take the last document, that will also help

[koryknick]

@thilkip - what is generating the input documents?

[thilkip]

a SQL snap gets the data from tables

[koryknick]

SQL Server 2016 (13.x) and later has a “FOR JSON” clause:

docs.microsoft.com

Format Query Results as JSON with FOR JSON - SQL Server

Format Query Results as JSON with FOR JSON (SQL Server)

You should be able to return the result set exactly how you want.

[thilkip]

the data coming from DB2