=Lookup

=Lookup pre-defined list function can also be called directly as a pre-defined list function to dynamically load lists from lookup tables.

Parameters remain the same as Lookup post processing function. However there is no need to enclose lookup within a ‘value’ function since the lookup value is not being set anywhere.

📘

All predefined list functions below must be preceded with '='

A few examples:

Example 1 - To return all distinct values of target parameter from Piped Drain class:

=Lookup($class.Piped Drain,[$attribute.Unique Asset ID] - {$attribute.Asset Name})
=Lookup($class.Piped Drain,{$attribute.Unique Asset ID} - [$attribute.Asset Name])

Example 2 - To return all values of target using lookup of source attribute across all asset classes:

=Lookup($class.*,{$attribute.Unique Asset ID} - {$attribute.Asset Name} ,$attribute.Unique
Asset ID , *)

Example 3 - To escape a ‘,’ in target, use \:

=Lookup($class.Piped Drain,{$attribute.Unique Asset ID} \, {$attribute.Asset Name},
$attribute.Unique Asset ID,*)