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. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

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
.


Updated June 14, 2019