2021.2

After selecting the file, take a look at the preview to ensure that the file is the right one and the
encoding correctly reads the data. Click Next.
For an Excel file you can make the following settings:
l First row contains field names: Uses the first row of the Excel sheet as headers, which
automatically names all extracted fields.
l Sheet: Select the sheet from which the data should be extracted.
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 selected column
has numbers, it will be sorted as a text.
For a CSV file the wizard will display the different settings it has detected, allowing you to
change them:
l Encoding: Defines which encoding is used to read the file.
l Separator: Defines which character separates each field in the file.
l Comment Delimiter: Defines which character starts a comment line.
l Text Delimiter: Defines which character surrounds text fields in the file. Separators and
comment delimiters within text are not interpreted as separator or delimiter; they are seen
as text.
l Ignore unparseable lines: Ignores any line that does not correspond to the settings
above.
l First row contains field names: Uses the first line of the CSV as headers, which
automatically names all extracted fields.
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 selected column
has numbers, it will be sorted as a text.
Tip
The Sort on option, combined with the Stop data mapping option of the "Action step" on
page264, allows to process only a group of items without having to examine all records.
(See also: "Action step properties" on page353.)
Verify that the data are read properly.
Page 205