Query Chain execution using Union transformation

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

Query Chain execution using Union transformation

A Union transformation joins two similar or multiple sets of columns data into one. Let’s execute a Query Chain using the ‘Union’ transformation.

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

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

• This action navigates the user to a new Query Chain session page.
• From the ‘Data Source’ tab, let’s drag and drop an ‘RDBMS Table’ icon onto 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 select ‘MSSQL’ from the ‘Database Type’ dropdown list and ‘MSSQL Northwind’ as the ‘Connection Name’ drop-down list.
• Click the ‘Navigator’ button.

• Let’s select ‘dbo.member’ table from the ‘Credit’ schema.

• Click the ‘dbo.member’ table to pick the table.
• Click the ‘Select’ button.

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

• Let’s drag and drop a ‘Union’ icon onto ‘Query Chain’ session page.
• Click the ‘Data Source’ tab again.

• Let’s drag another ‘RDBMS’ Table onto the Query Chain session page.
• Double tap the ‘Read data from Table’ widget.

• This action pops up a ‘Read data from Table’ pop-up window.
• Let’s select ‘MSSQL’ from the ‘Database Type’ dropdown list and ‘MSSQL Northwind’ as the ‘Connection Name’ drop-down list.
• Click the ‘Navigator’ button.

• Let’s select ‘dbo.member2’ table from the ‘Credit’ schema.

• This action picks and loads the ‘dbo.member2’ table.
• Click the ‘Select’ button.

• This action closes the ‘RDBMS Table’ widget saving its data.
• The user is navigated to the ‘Query Chain’ session page.

• Join the second RDBMS Table (Read data from “Credit.dbo.member2” for data source “MSSQL Northwind”) to the ‘Union Datasets’ widget.
• Double tap the ‘Union Datasets’ widget.

• A ‘Union Datasets’ pop-up window is displayed.
• Let’s checkbox ‘Remove duplicates(Union / Union All)’ option.
• Click the ‘Select’ button.

• This action closes the ‘Union Datasets’ widget saving its data.
• Click the ‘Output’ tab.

• Let’s drag an ‘RD Output’ icon onto the Query Chain session page.
• Double tap the ‘RD Output’ widget.

• An ‘RD Output’ pop-up window is displayed.
• 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 (20000).

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