Query Chain using unpivot data transformation

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

QC execution using UnPivot data Transformation

To learn more, let us walk through the below procedure:

Click the ‘QUERY STUDIO’ module.
Hover on the ‘Query Builder’ snippet from the left pane options.
Click the ‘Query Chain’ option.

This action navigates the user to the Query Chain session page.
Let’s drag and drop an ‘RDBMS Table’ icon on to the Query Chain session page.
Double tap the ‘Read data from Table’ widget.

A ‘Read data from Table’ pop-up window is displayed.
Let’s add the ‘Database Type’ as ‘PostgreSQL’ and ‘Connection Name’ as ‘PostgreSQL Northwind-QA_AWS.’
Click the ‘Navigator’ button.

Let’s select ‘order_details’ table from the ‘Public’ schema.

Click the ‘order_details’ table to pick the table.
This action loads the columns data from the selected table.
Click the ‘Select’ table.

This action closes the ‘RDBMS Table’ widget saving its data.
Click the ‘Transformations’ tab.

Let’s drag and drop ‘UnPivot’ icon onto the Query Chain session page.
Click the ‘UnPivot Data’ widget.

An ‘UnPivot Data’ pop-up window is displayed.
Let’s select and checkbox the ‘Column Name.’

Note: As the user select the ‘Column Name’, all the columns are selected by default.

Add ‘orderid’ for ‘Unpivot For’ and ‘productid’ for ‘UnPivot By.’
Click the ‘Save’ button.

This action closes the ‘UnPivot Data’ widget saving its data.
Click the ‘Output’ Tab.

Drag and drop an ‘RD Output’ icon onto the Query Chain session page.
Double tap the ‘RD Output’ widget.

This action pops-up an ‘RD Output’ window.
Click the ‘Select’ button.

This action closes the ‘RD Output’ widget saving its data.
Click the ‘Execute Now’ button.

A green color tick mark indicates the Query Chain is executed successfully.
A monitor mode is enabled.
Let’s click on the ‘RD Output’ count icon (10775).

This action navigates the user to the ‘Results’ tab displaying the executed data.