Joined data based on a matching key or condition

This example pipeline demonstrates how to join two files using the Join Snap. The pipeline combines records from two sources based on a matching key or condition - in this case, the customer_id.


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

Download this pipeline

  1. Configure the JSON Generator Snaps to provide input data as shown below.

    Customer Details (JSON Generator) Item and Cost (JSON Generator)

    Customer Details output

    Items and Cost output
    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. Configure the Join Snap as shown below. This Snap merges data from both JSON Generator Snaps (Item & Cost and Customer Details) into a single output stream, combining order and customer information.
    Join Settings Configuration
  3. Upon validation, the Snap displays the joined output, resulting from a consistent input schema. The key name customer_id is the same as in both views, therefore, the Join Snap prefixes it with the right view label in the output data.
    Join output

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.