cancel
Showing results for 
Search instead for 
Did you mean: 

Merge documents into one big document

walkerline117
Contributor

Hi,

Currently when I use Oracle select/Oracle execute snaps to query data from Snaplogic, it will return multiple documents as output from those snaps(one row per doc).

Is there a way i can merge them together into one json array or one doc?

Thanks

16 REPLIES 16

thilkip
New Contributor

Can one of you let me know if there was a solution for this?

heidi_andrew
Contributor

I have to do this a lot. The sql must have a way to match up on all of these. For example, one sql pulls the employee address. The dependent tables do not have an address on them so i have to put the employee's address on the dependent address rows matching on employee_id. I have a pipeline with 21 pipelines in it to get everything on one line. When you do this sort of pipeline, in the mapper, you will see inputs from both documents. For this file, i only want dependent records on my file but i want the input from the EE record to update the dependent's address fields. Those will show on the last mapper. bring in all of the Dependent fields but on the address fields, bring in the EE's address. These will show as Input_1_Address_line_1 for example. 

 

heidi_andrew_0-1705496328060.png