LOOKUP

Basic Overview

Description	Performs an approximate match lookup in a one-column and returns the corresponding value from another one-column
Signature	LOOKUP('Node1', 'Node2', 'Node3', [DefaultReturnValue], [LevelName])
Parameters	Node1: Lookup Value - The value to search for in the Index table Node2: Index - A column of data that is sorted in ascending order. The LOOKUP function searches for value in this range Node3: Return Value - Is a range that contains the result DefaultReturnValue: In case a lookup value is not found a default value will be given. System default is: -1 LevelName: IndexLevel: By default is the level 'Sequence'
Limitations	Important: The values in the index must be placed in ascending order (alphabetical sorting), otherwise, LOOKUP might not return the correct value Also important: The “Index” values have to be sorted as 001, 002, 003, … instead of 1, 2, 3, … Otherwise Valsight will consider e.g. a 11 to be smaller than a 2. This is further explained at the bottom of the page (sequence dimension) Index level should not be included in Lookup value table

Example

Lookup Value:

Employee	Salary
E1	50.000

Index:

Sequence	Threshold
0	0
1	10.000
2	30.000
3	60.000

Return Value:

Sequence	Tax
0	0
1	0
2	1.000
3	2.000
4	3.000

LOOKUP(lookup_value, index, return_value)

Employee	Tax
E1	1.000

Expanding the Sequence Dimension

The sequence dimension is a default dimension that defines the steps of a time value. In rare cases, it can be helpful or even necessary to edit the sequence dimension to support complex scenarios on a monthly level. Additional info on the sequence dimension and how to modify it can be found at: Configure the Sequence dimension .