VLookup Operation

Here is the 'VLookup' operation for Numeric type transformation

VLookup

Key Value

Match the input with the lookup key and choose the type of operation

1. Equals

2. Not Equals

3. Starts with

4. Contains

Specify the lookup key and the corresponding value to use.

Lookup Table

Using this function requires defining a lookup table via Dataworkz.

Match the input with the lookup key of the specified Lookup Table to return the following -

• The value corresponding to the lookup key.

• Boolean with a value of “TRUE” for values found in the lookup table.