SimpleCsvFileLookupService

Description:

A reloadable CSV file-based lookup service

Tags:

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

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 NiFi Expression Language.

NameDefault ValueAllowable ValuesDescription
CSV FileA CSV file.
Supports Expression Language: true (will be evaluated using variable registry only)
CSV FormatDefault
  • Excel
  • MySQL
  • TDF
  • PostgreSQLCsv
  • InformixUnloadCsv
  • Default
  • RFC4180
  • InformixUnload
  • PostgreSQLText
Specifies which "format" the CSV data is in, or specifies if custom formatting should be used.
Character SetUTF-8The Character Encoding that is used to decode the CSV file.
Supports Expression Language: true (will be evaluated using variable registry only)
Lookup Key ColumnLookup key column.
Supports Expression Language: true (will be evaluated using variable registry only)
Lookup Value ColumnLookup value column.
Supports Expression Language: true (will be evaluated using variable registry only)
Ignore Duplicatestrue
  • 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.