Description:

A reloadable CSV file-based lookup service. When the lookup key is found in the CSV file, the columns are returned as a Record. All returned fields will be strings.

Tags:

lookup, cache, enrich, join, csv, reloadable, key, value, record

Properties:

In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property supports the Expression Language Guide.

Name

Default Value

Allowable Values

Description

CSV File

A CSV file that will serve as the data source.

Supports Expression Language: true (will be evaluated using variable registry only)


CSV Format

Default
  • Excel
  • MySQL
  • TDF
  • PostgreSQLCsv
  • InformixUnloadCsv
  • Oracle
  • Default
  • RFC4180
  • InformixUnload
  • PostgreSQLText
Specifies which "format" the CSV data is in.

Character Set

UTF-8 The Character Encoding that is used to decode the CSV file.

Supports Expression Language: true (will be evaluated using variable registry only)


Lookup Key Column

The field in the CSV file that will serve as the lookup key. This is the field that will be matched against the property specified in the lookup processor.

Supports Expression Language: true (will be evaluated using variable registry only)


Ignore Duplicates

true
  • true
  • false
Ignore duplicate keys for records in the CSV file.

State management:

This component does not store state.

Restricted:

This component is not restricted.

System Resource Considerations:

None specified.