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

Transform Data — Add Derived Columns

Use the Projection transformation to add computed or derived columns to a data stream.

Overview

The Add Derived Columns feature in Query Studio uses the Projection transformation to compute new columns from existing data — for example, date formatting, arithmetic calculations, or string concatenation. Derived columns are added to the output stream without modifying the source.

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.
• A Query Chain with a data source widget has been configured.

Steps

Path: Data Trust › Query Studio › Transform Data — Add Derived Columns

Figure 1: Start

This step shows Start in the Transform Data — Add Derived Columns workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 2: transformation tab

The Transformations tab lists all available data transformation widgets — Filter, Projection, Aggregation, Join, Pivot, Unpivot, and more. Drag the required transformation onto the canvas and connect it between the data source and output widgets.

Figure 3: Projection

The Projection widget selects, renames, or derives columns from the input data stream. Use it to add computed columns, remove unnecessary fields, or rename columns before passing data to the next stage.

Figure 4: new derived column

The Projection widget selects, renames, or derives columns from the input data stream. Use it to add computed columns, remove unnecessary fields, or rename columns before passing data to the next stage.

Figure 5: 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 6: execution progress

Monitor mode shows the live execution progress of the Query Chain as each widget processes data sequentially. Watch the progress indicators to confirm all stages complete successfully before reviewing the output.

Figure 7: Result tab

The Result tab displays the output data returned by the query or Query Chain execution. Review row counts, column values, and data quality before saving or using the output in downstream processes.