lookupRel(var1,var2)
This relative lookup
function returns the value of the first argument in a row number
calculated by adding the values of the second argument to the current
row number. The first argument can be of any variable type. Note
that both arguments must be variables. For example, suppose there
is a variable called !key!, and its values in the first four rows
of the dataset are 3, 27, 49, 31; if you type the transform
$lookupRel(!flow1!,!key!)
then the results in the first four rows of
the dataset will be the original values of !flow1! from rows 4,
29, 52, and 35.
Provide Feedback