2018.1

Processing
The task parses each level of the metadata and, for each field of the specified name it finds, a
lookup is made. If a field of the same name appears on multiple levels, the lookup will happen
for all fields, on all levels, individually.
Output
The original data file is unchanged. Metadata is updated according to the specified criteria.
Properties
General Tab
l Excel group
l Excel workbook:The full path and file name of a Microsoft® Excel® workbook (.xls
or .xslx file). You can use the Browse button on the right to browse to the file on
your computer.
l Excel worksheet:The name of the worksheet you want to use. Once a workbook is
open, this drop-down will automatically list all the available worksheets.
l
Refresh button:If you have modified the original Microsoft® Excel® workbook to
add a sheet, click this button to refresh the list of worksheets.
l Metadata group
l Lookup Field:The name of the metadata field that will be used to determine which
row should be returned. The Metadata field can be on any level.
l Lookup Column:The name of the column in the Microsoft® Excel® worksheet that
corresponds to the contents of the Lookup Field.
l Action:What to do with the resulting data from the Microsoft® 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.
Page 370