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'
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
LOOKUP(lookup_value, index, return_value)
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 here.
You may contact the Valsight Customer Support via: