2020.1

l Properties that have their scope set to "Automation variable". These are retrieved via
automation.variables(see "Objects" on page378), for example
automation.variables.FieldList.
Properties that have their scope set to "Each record" and can not be used because the SQL
query is executed before any record is created. For the same reason, variables declared in
other Steps can not be used.
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217.
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.
Page 327