2019.1

Table Of Contents
l
Action: What to do with the resulting data from the Microsof Excel® worksheet.
This can be:
l
Add Field: Creates a new field with the data. This may cause multiple fields to
be created.
l
Replace field value: Replaces any existing field with the new content. Only
the last result will be displayed. If the field does not exist, it will create it.
l
Append field value: Ads the data to the existing field within the same one. No
"separator" is added. If the field does not exist, it will create it.
l
Result Field: The Metadata field name in which the result should be stored. This
field will appear in the same Metadata level as the Lookup Field.
l
Result Column: The name of the column where the information you want to retrieve
is located. For example, this could be a client email or full name.
l
button: Ads a new lookup line. You can have as many lines as you want. The
lines will be executed in order from top to bottom, so you can rely on a previous line
to bring additional information.
l
button: Removes the currently selected (highlighted) line.
l
button: Moves the currently selected line up one place.
l
button: Moves the currently selected line down one place.
l
Search option group
l
Match case: Will force the lookup column names to be in exactly the same case as
the Lookup column name. This means if you type in "CustomerID" in the lookup
column and the actual column is named "customerid", it would not return any result.
On Error Tab
For a description of the options on the On Error tab see "Using the On Error tab" on page92.
Miscellaneous Tab
The Miscellaneous tab is common to all tasks.
It contains a text area (Task comments) that lets you write comments about the task. These
comments are saved when the dialog is closed with the OK button and are displayed in the
Task Comments Pane.
Page 491