2020.2

Example
= SELECT {automation.variables.FieldList} FROM {automation.jobInfo.JobInfo9}
If the Workflow variable defined as FieldList contains the value "id,name" and Job Info 9
contains the value "MyTable", then this custom query, once parsed, yields the following SQL
statement:
SELECT id,name FROM MyTable
which is then executed.
Steps pane
The Steps tab displays the data mapping workflow: the process that prepares and extracts data.
The process contains multiple distinct steps and is run for each of the records in the source
data. For more information about the steps and how to use them, please refer to Steps and
"Data mapping workflow" on page219.
Finding a step
To find a certain step in a large data mapping workflow, start typing the name of the step in the
Find Step field at the top of the Steps pane, and press Enter. Use the buttons next to the
number of search results to navigate through the matching steps.
Note that the search is case-insensitive.
Moving a step
To rearrange steps, simply drag & drop them somewhere else on the colored line in the Steps
pane.
Alternatively you may right-click on a step and select Cut Step or use the Cut button in the
Toolbar. If the step is Repeat or Condition, all steps inside it will also be placed on the
clipboard. To place the step at its destination, right-click any step and select Paste Step, or use
the Paste button in the toolbar. The pasted steps will be positioned below the selected step.
Viewing step details
Hovering over the task shows a tooltip that displays some of the details of that step. To see all
details for a step, click on the step and take a look at the Step properties pane ("Step properties
pane" on page333).
Clicking on any Extract step in the Steps pane highlights any area in the Data Viewer from
which it extracts data.
Page 331