2021.1

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352.)
Verify that the data are read properly.
Finally click Finish. All data fields are automatically extracted in one extraction step.
Page 205