Ask Your Question

Revision history [back]

You can't do this directly, but you have some options:

  • Write a custom processor in Python, Groovy, JavaScript, or even Java, to read it in, parse it, put it in a map, and do the lookup.
  • Create a pipeline to convert the CSV to JSON, then copy/paste the JSON into a Static Lookup processor.
  • Create a pipeline to load the CSV into a supported lookup store (JDBC / HBase / Redis etc) and do the lookup there

The first two are only viable if the file is small, i.e. its contents will fit into memory.

You can't do this directly, but you have some options:

  • Write Use a Python, Groovy, or JavaScript Evaluator, or even a custom processor in Python, Groovy, JavaScript, or even Java, Java processor, to read it in, parse it, put it in a map, and do the lookup.
  • Create a pipeline to convert the CSV to JSON, then copy/paste the JSON into a Static Lookup processor.
  • Create a pipeline to load the CSV into a supported lookup store (JDBC / HBase / Redis etc) and do the lookup there

The first two are only viable if the file is small, i.e. its contents will fit into memory.