2021.2

Connect 2018.2 DataMapping Updates
Ignore Blank Lines
Option added to the DataMapper Settings to ignore any blank lines in the data. (SHARED-57790)
Dynamic SQL Queries
Custom SQL queries now support the use of dynamic elements which can be built using
JavaScript syntax. This allows an SQL query to use information passed on by Workflow to
dynamically customize the query. (SHARED-34301)
For instance, a custom query could contain the following code:
=SELECT {automation.variables.FieldList} FROM {automation.jobInfo.JobInfo9}
This would get converted dynamically to something like SELECT id, name FROM MyTable based
upon the values of Workflow process variables FieldList and JobInfo(9).
Page 1660