Query Chain execution using Aggregation transformation

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

Query Chain execution using Aggregatation transformation

An Aggregation Transformation in Query Chain is used to perform different aggregate functions such as Count, Minimum, Maximum, Average, and Sum apart from ‘Data Type’ change. Let’s execute QC using Aggregation transformation.

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

• Click the ‘Query Studio’ module.
• Hover on the ‘Query Builder’ snippet.
• Click the ‘Query Chain’ option.

• The user is navigated to the new Query Chain session page.

• From the ‘Data Source’ tab, let’s drag and drop an ‘RDBMS Table’ icon onto Query Chain create and edit page.

Note: All other Data Source icons including ‘RDBMS Table’ gets disabled as the user drags it onto 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 ‘Postgre SQL’ from ‘Database Type’ drop-down list and ‘PostgreSQL Northwind-QA_AWS’ from ‘Connection Name’ drop-down list.
• Click the ‘Navigator’ button.

• A ‘Navigator’ slide screen is displayed on the right side of the page.
• Let’s select the ‘Orders’ table from the ‘Public’ schema.

• Click the ‘Orders’ table to pick the table.
• Click the ‘Select’ button.

• This action saves the ‘RDBMS table’ widget data by closing it.
• The user is navigated to the Query Chain session page.
• Click the ‘Transformations’ tab.

• Let’s drag and drop ‘Aggregation’ icon onto the Query Chain session page.
• Double tap the ‘Aggregate data from <Data Source>’ widget.

• An ‘Aggregate data from Data Source’ pop-up window is displayed.

Note: By default, all the Column Names are selected.

• Let’s select and checkbox ‘Orderid’ and ‘employeeid’ from the ‘Column Name’ and change the Aggregation to ‘Count’ for Orderid and ‘Avg’ to employeeid.
• Click the ‘Save’ button.

• This action closes the ‘Aggregation’ widget saving its data.
• The user is navigated to the ‘Query Chain’ session page.
• Click the ‘Output’ tab.

• Let’s drag and drop an ‘RD Output’ icon.
• 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 (1).

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