Merge Datasets - Gridscript Pipeline

Import the left-hand dataset into the data pipeline to enable structured data ingestion and prepare it for joining with related datasets.

Import
Idle
left
Upload File
Import the right-hand dataset to provide complementary data sources required for accurate dataset merging and relational analysis.
Import
Idle
right
Upload File
Perform an inner join merge between the left and right datasets using shared key fields to create a unified, analytics-ready merged dataset.
Merge
Idle
Left field
Right field
Output field
Left join keysRight join keysJoin type
Inner join
Merge two context fields with SQL-like joins. Works with both list-of-lists (table rows) and list-of-objects; composite keys are supported using comma-separated values.
Export the merged dataset to Excel (XLSX) format to support spreadsheet-based reporting, business analysis, and stakeholder collaboration.
Code
Javascript
Idle
Export the merged dataset to CSV format to enable lightweight data sharing, system interoperability, and analytics pipeline integration.
Code
Javascript
Idle
Export the merged dataset to JSON format to provide a machine-readable output optimized for APIs, automation, and modern data workflows.
Code
Javascript
Idle