Number of input and output field

Number of input field	:	One
Number of output field	:	One

This transformation function is used to look up data in a reference range file. It is applicable when the reference data can fit into the memory of each worker. If the reference data is too large, it is recommended to use a reduce-side join assembly instead.

The parameters of this transformation function are:

• File Reference
  The name of the reference file
• Field Splitter
  The delimiter used to split each row of the reference file into fields. The default delimiter is a comma (,).
• Start Index Ref. Field
  The index of the field representing the start of the range to be matched against the input value.
• End Index Ref. Field
  The index of the field representing the end of the range to be matched against the input value.
• Index Of Output Field
  The index of the field whose value will be returned as the output.