Table of Contents

Search

  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. XMap
  7. Libraries
  8. Schema Object
  9. Command Line Interface
  10. Scripts
  11. Parsers
  12. Script Ports
  13. Document Processors
  14. Formats
  15. Data Holders
  16. Anchors
  17. Transformers
  18. Actions
  19. Serializers
  20. Mappers
  21. Locators, Keys, and Indexing
  22. Streamers
  23. Validators, Notifications, and Failure Handling
  24. Validation Rules
  25. Custom Script Components

Data Transformation User Guide

Data Transformation User Guide

LookupTransformer

LookupTransformer

The
LookupTransformer
transformer looks up a value in a table.
The following table describes the properties of the
LookupTransformer
transformer:
Property
Description
disabled
Determines whether the Script ignores the component and all of the child components. Use this property to test, debug, and modify a Script. You can choose one of the following options:
  • Selected. The Script ignores the component.
  • Cleared. The Script applies the component.
The default is cleared.
look_at
Defines the type of lookup table used by the transformer. You can choose one of the following options:
  • DynamicTable. The
    table
    property of the
    look_at
    property defines a data holder that contains the table. For more information, see DynamicTable.
  • InlineTable. The
    table
    property of the
    look_at
    property defines a list of
    Entry
    components, each of which contains a
    key
    and a
    value
    . For more information, see InlineTable.
  • XMLLookupTable. The
    xml_file_name
    property of the
    look_at
    property defines the path and file name of an XML file that defines the table. For more information, see XMLLookupTable.
  • [TableName]. A
    DynamicTable
    ,
    InlineTable
    , or
    XMLLookupTable
    defined at the global level of the Script.
Default is blank.
name
A descriptive label for the component. This label appears in the log file and the
Events
view. Use the
name
property to identify the component that caused the event.
optional
Determines whether a component failure causes the parent component to fail. You can choose one of the following options:
  • Selected. Component failure does not cause the parent component to fail.
  • Cleared. Component failure causes the parent component to fail.
Default is cleared. For more information about component failure, see Failure Handling.
remark
A user-defined comment that describes the purpose or action of the component.
If you use the same lookup table repeatedly, consider defining an
InlineTable
or an
XMLLookupTable
at the global level of the Script. You can then reference the table by name in the
look_at
property.
For example, you can configure a
LookupTransformer
to look up values in the following table:
Key
Value
1
George Washington
2
John Adams
3
Thomas Jefferson
4
James Madison
If the input of the transformer is
3
, the output is
Thomas Jefferson
.