How to use the DLOOKUP operation with Computed Attributes
Definition
The DLOOKUP operation is similar to the VLOOKUP you will find in Excel, except it requires a dictionary. DLOOKUP will replace values based on that dictionary.
Example
DLOOKUP($ATT.COLOR, {"red": "rojo","blue": "azul"},"not defined")
$ATT.COLOR value: red
Result: rojo
Syntax Guide
DLOOKUP(value, dictionary, [default])
value - The value to replace
dictionary - A set of keys and their corresponding values for replacement enclosed in brackets
default - [ OPTIONAL ] - When no value is found, this defines the default value
What's Next
- Learn more about how to write formulas
- Check out the REPLACE operation
- Check out the SUBSTITUTE operation
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇