Number of input and output field

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

This transformation function is used to retrieve a reference where the length of the reference key is not fixed.

The parameters of this transformation function are:

• File Reference
  The name of the reference file, including its path.
• Field Splitter
  The delimiter used to split fields in the reference file. If not specified, the default delimiter is a comma (,).
• Index of Ref. Field
  The index of the field in the reference file that will be used as the reference key. If not specified, the default is 0.
• Index of Output Fields
  he index (or indices) of the field(s) in the reference file that will be returned as output. Multiple indexes should be separated by a hyphen (-).
• Range Length of Ref. Field
  The possible lengths of the reference field. For example, 8-7-6 means the reference field can have a length of 8, 7, or 6 characters.

For example, the contents of the reference file data.txt are as follows:

 ab|data1
 abc|data2
 ac|data3

If the parameters are filled with the following values:

• File Reference : data.txt
• Field Splitter : |
• Index of Ref. Field : 0
• Index of Output Fields : 1
• Range Length of Ref. Field : 4-1

A stream with input 'abc123' will get the output 'data2'
A stream with input 'abc' will also get the output 'data2'.