2022.1

l Table: Displays the tables and stored procedures available in the database. The selected
table is the one the data is extracted from. Clicking on any of the tables shows the first line
of the data in that table.
l
Custom SQLbutton : Click to open the SQL Query Designer (see"SQL Query
Designer" on page361) and type in a custom SQL query. If the database supports stored
procedures, including inner joins, grouping and sorting, you can use custom SQL to make
a selection from the database, using whatever language the database supports.
The query may contain variables and properties, so that the selection will be dynamically
adjusted each time the data mapping configuration is actually used in a Workflow
process; see"Using variables and properties in an SQL query" on page362.
l Encoding: Defines what encoding is used to read the Data Source (US-ASCII, ISO-
8859-1, UTF-8, UTF-16, UTF-16BE or UTF-16LE ).
l Sort on: Allows to select a field on which to sort the data, in ascending (A-Z) or
descending (Z-A) order. Note that sorting is always textual. Even if the sorting column has
numbers, it will be sorted as a text.
With a Custom Query, this option is not available.
l Skip empty lines: Ignore any row that has no content, e.g. only nulls or empty strings.
Note that spaces are characters and thus considered content.
Text file Input Data settings
Because text files have many different shapes and sizes, there are many options for the input
data in these files.
l Encoding: Defines what encoding is used to read the Data Source (US-ASCII, ISO-
8859-1, UTF-8, UTF-16, UTF-16BE or UTF-16LE ).
l Selection/Text is based on bytes:Check for text files that use double-bytes characters
(resolves width issues in some text files).
l Add/Remove characters: Defines the number of characters to add to, or remove from,
the head of the data stream. The spin buttons can also increment or decrement the value.
Positive values add blank characters while negative values remove characters.
l Add/Remove lines: Defines the number of lines to add to, or remove from, the head of
the data stream. The spin buttons can also increment or decrement the value. Positive
values add blank lines while negative values remove lines.
l Maximum line length: Any line that is longer than the given maximum line length will be
split at the maximum line length, as often as necessary. This option is used to cut (and
wrap) long lines into logical blocks of data.
Page 350