DLOOKUP Operation

How to use the DLOOKUP operation for 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("red", {"red": "rojo","blue": "azul"},"not defined")

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