2022.1

fields, even if the field delimiter is the semicolon.
For an explanation of all the options, see: "CSV file Input Data settings" on page347.
Settings for an Excel File
For an Excel file you have to specify which sheet to use. You can also set how many lines
should be skipped, if the first row contains field names or not, and how the data should be
sorted. See: "Excel file Input Data settings" on page348.
Excel has its own way to display dates. You can specify if the Data Viewer should display
dates just as Excel does, or not. That's important because extracting a Date value will only be
successful if the expected date format matches the actual format of a date in the Data Viewer.
This Editor Data Format setting is found on the Settings pane; see: "Editor Data Format" on
page359.
The expected date format is set somewhere else; see: "Default Data Format" on page360.
Settings for a PDF File
PDF files have a clear and unmovable delimiter: pages. So, the Input Data settings are not
used to set delimiters. Instead, these options determine how words, lines and paragraphs are
detected when you select content in the PDF to extract data from it.
For an explanation of all the options, see: "PDF file Input Data settings" on page348.
Settings for a database
Databases all return the same type of information. Therefore the Input Data options for a
database refer to the tables inside the database. Clicking on any of the tables shows the first
line of the data in that table.
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.
For an explanation of all the options, see: "Database Input Data settings" on page349.
Settings for a text file
Because text files have many different shapes and sizes, there are a lot of input data settings
for these files. You can add or remove characters in lines if it has a header you want to get rid
of, or unwanted characters at the beginning of your file, for example; you can also set a line
Page 250