2019.1

item description as found on a region of the current data page. The line item descriptions
appearing on the resulting page produced by the design tool are custom data selections whose
value come from the corresponding ItemDesc Metadata fields. The Lookup in Microsoft®
Excel® Documents action task updates the value of all 'ItemDesc' Metadata fields with their
corresponding foreign language descriptions.
Input
Any compatible data file. This task 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.
Task 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.
Page 490