Join Dataset

You are viewing Query Studio - Query Builder documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Query Studio › Query Builder

Join Dataset in Query Chain

Merge two data streams using a key-based Join transformation in a Query Chain.

Overview

A Query Chain (QC) is a multi-step data pipeline built on the Query Studio canvas. It connects data source widgets (RDBMS, Query, REST API, CSV, etc.) through transformation widgets (Filter, Aggregation, Join, Pivot, Unpivot, Projection) to an RD Output or file export. Query Chains can be scheduled, emailed, and reused as inputs to scenarios.

Note: Ensure all required connection profiles are configured in the Administration module before building queries or Query Chains in this workflow.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• At least one connection profile and one saved query are available in the system.

Steps

Path: Data Trust › Query Studio › Join Dataset in Query Chain

Figure 1: Query Chain Header widget

This step shows Query Chain Header widget in the Join Dataset in Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 2: RDBMS select table

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table, then click Select to add it to the query.

Figure 3: Query Widget Select CSV Query

The Query Widget Select CSV Query configures a CSV file as the data source for the query. Select the file connection profile, browse to the file location, and map the delimiter and header settings before saving.

Figure 4: Join Widget

The Join widget merges two data streams based on matching key columns, similar to a SQL JOIN operation. Select the join type (Inner, Left, Right, or Full) and map the key columns from both input streams.

Figure 5: Aggregation Widget

The Aggregation widget groups records by selected dimensions and computes aggregate values such as SUM, COUNT, AVG, MIN, or MAX. Define the group-by columns and the aggregate expressions, then save the widget.

Figure 6: RD Output

The RD Output widget captures the final result set from the Query Chain for use in downstream processes. Configure the output name and format, then save the widget to make the results accessible to other scenarios and reports.

Figure 7: QC Executed

Click Execute Now to run the query immediately and fetch the result set. The results appear in the Results tab, and the execution status is displayed in the progress indicator.

Figure 8: QC Result

This step shows QC Result in the Join Dataset in Query Chain workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.