Skip to main content

Transform Query

Using Creating Transform Queries​

Transform queries manipulate existing standard or aggregate queries using DPL expressions to produce data. The results of a transform query is always presented as a table regardless of whether the dimension of the input. (For more information, see Understanding transform queries.)

To create a transform query

  1. Right-click the Queries folder in the Data pane (bottom left pane) and select New Transformation from the shortcut menu. -or- Right-click a blank space in the background of the document area and select Create Transform Query.

  2. The upper right side of the query editor displays a list of the queries in the current DPL package as well as a categorized list of the available DPL functions.

tip

Hover the mouse over any function in the query editor to see a tool tip displaying the function's purpose, syntax, and required parameters.

♣ Drag and drop the desired tables, fields, and functions to the text box at the bottom of the editor to construct the desired expression. Type in the appropriate DPL expression syntax to connect the drag-and-dropped elements.

♣ You can also type all expression elements, values, and syntax directly into the work area.

♣ In case that the desired query contains parameter(s), the parameter(s) must be passed to the query by using

'({Parameter})' syntax. For example, if the parameter is of text type, the syntax should look like "[[New Standard Query('{Parameter}')]]"

  1. To preview the results of your query, click the preview icon on the toolbar. The data returned by your query appears in the preview pane. To adjust the amount of data returned in the preview, use the Start row and Max row sliders above the preview pane.

  2. When you are satified with the query, go to the File menu and select Save [query name] where [query name] is the actual name of your query.