Merging Documents

You can use the Merge Join type to merge documents.

In this example:
  • $input comes into input0 and contains a value of 42
  • $output comes into input1 and contains a value of 84

Joined data based on a matching key or condition example Pipeline.

  • Join type: Merge
  • Join path:
    • Left path: (expression toggle on) $input
    • Right input view: input1
    • Right path: (expression toggle on) $output
    • Sorted streams: Ascending
Merge Result:
Join Merge Result
If the Join type is changed to Outer, the result is:
Join - Outer
If the Join type is changed to Left Outer, the result is:
Join - Left Outer

If the Join type is changed to Inner, no results are returned because there are no shared records.

If both inputs have a record of $day with a value of today added, set the paths to $day and the Join type to Inner. The result will look like this:
Join - I nner

Downloads

Note: To successfully reuse pipelines:
  1. Download and import the Pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide Pipeline parameters as applicable.