8.7

task, otherwise it will run as many times as there are metadata sequences, which will
result in decreased performance.
Input
Any compatible data file, requires metadata to be present.
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:
Page 430