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

Query Chain using XML as Data Source

Parse and query XML file data using a Query Chain data source widget.

Overview

This guide shows how to use an XML file as a data source in a Query Chain. Data Trust parses the XML structure using a configured root element path and maps the elements to tabular columns for downstream transformation and output.

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.
• An XML file connection profile has been configured.

Steps

Path: Data Trust › Query Studio › Query Chain using XML as Data Source

Figure 1: Query cahin navigation

Navigate to the Query Studio module and select Query cahin navigation to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.

Figure 2: Query chain_Drag XML widget

Drag the Query Chain_Xml Widget widget from the palette and drop it onto the Query Chain canvas. Once placed, click the widget to open its configuration popup and complete the required settings.

Figure 3: Query chain_read data from table pop up

This step shows Query chain_read data from table pop up in the Query Chain using XML as Data Source workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 4: Querychain_read data from table_Toggle to local

This step shows Querychain_read data from table_Toggle to local in the Query Chain using XML as Data Source workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 5: Querychain_Read data from table_Choose required file

The Querychain_Read data from table_Choose required file 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 6: Querychain_Read data from table_Choose required file_Actions buttons population

The Querychain_Read data from table_Choose required file_Actions buttons population 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 7: querychain_read data from table _added root element and data model

This step shows querychain_read data from table _added root element and data model in the Query Chain using XML as Data Source workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 8: Querychain_read data from table_Preview data

The Preview Data button fetches a sample of records from the selected table or query result. Verify the column names and sample values before proceeding to confirm the data source is correctly configured.

Figure 9: Querychain_read data from table_save widget

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.

Figure 10: Querychain_Read data from table_Drag filter widget

The Filter transformation restricts the records passing through the Query Chain to only those matching the specified conditions. Define the filter expression using field dropdowns, operator selectors, and value inputs, then save the widget.

Figure 11: Querychain_Read data from table_darg applied filter data

The Filter transformation restricts the records passing through the Query Chain to only those matching the specified conditions. Define the filter expression using field dropdowns, operator selectors, and value inputs, then save the widget.

Figure 12: Querychain_Read data from table_saved filter_output tab

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.

Figure 13: Querychain_Dragged Rd output

Drag the Querychain_Ged Rd Output widget from the palette and drop it onto the Query Chain canvas. Once placed, click the widget to open its configuration popup and complete the required settings.

Figure 14: Querychain_RD output widget pop up

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 15: Query chain_Execute now button

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 16: Count at RD output widget_after executions

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 17: Count at RD output widget_Results

The Count at RD output widget_Results 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.