Combine data without any matching key or condition using Union Snap

This example pipeline demonstrates how to append records from multiple sources without needing a matching key between two files using the Union Snap. It combines order information, that is items and costs with the customer details. The pipeline comprises two segments, each independently generating JSON data, which are then merged with a Union snap.



Download this Pipeline

  1. Configure the JSON Generator Snap with input data as shown below.
    Customer Details (JSON Generator) Item & Cost (JSON Generator)




    Generates JSON data with customer information, including customer IDs, names, email addresses, and mailing addresses. Generates JSON data with order information, including order IDs, customer IDs, order dates, and item details such as item IDs, names, quantities, and prices.
  2. Next, connect the Union Snap to the upstream Snaps. The Union Snap combines the output from both JSON Generator snaps, merging the order and customer data into a single stream.


  3. Upon validation, the Snap displays the following joined output as a result of providing a consistent input schema. Note that though the customer_id is common for both the input Snaps here, the Union Snap simply appends the data from both of them.


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.