find-value-in-dictionary
Description
find-value-in-dictionary adaptor finds a key in a dictionary and returns its associated value.
If no value is found, it will return a specified default value. If no default value is set, no value will be returned.
Inputs
dictionary
Type: dictionary
Required: Yes
The dictionary to lookup the key-value pair.
key
Type: text
Required: Yes
The key to be found.
case sensitive
Type: boolean
Required: No
When set to False, lowercase and uppercase letters are treated as equivalent when matching values, e.g. Peru = peru. If unspecified, defaults to False.
match diacritics
Type: boolean
Required: No
When set to False, letters with and without diacritics are treated as equivalent when matching values, e.g. Perú = Peru. If unspecified, defaults to False.
default value
Type: text
Required: No
A value to be returned if key is not found in dictionary. If unspecified, no value will be returned.
Outputs
value
Type: text
The value in dictionary associated to key if found, otherwise default value will be returned.
Examples
Example 1: Default behaviour.
Inputs:
dictionary:
GB
United Kingdom
TR
Turkey
US
United States
IND
India
key: US
case sensitive: null (empty)
match diacritics: null (empty)
default value: null (empty)
Outputs:
value: United States
-> Found the value United States for the key US in the datatable.
Example 2: If no key is found, return a default value.
Inputs:
dictionary:
GB
United Kingdom
TR
Turkey
US
United States
IND
India
key: JP
case sensitive: null (empty)
match diacritics: null (empty)
default value: Value not found
Outputs:
value: Value not found
-> Since the key JP doesn't exist in the dicitionary, the default value Value not found is returned.
Example 3: Find value when case sensitive is set to true.
Inputs:
dictionary:
GB
United Kingdom
TR
Turkey
US
United States
IND
India
key: us
case sensitive: True
match diacritics: True
default value: United States of America
Outputs:
value: Value not found
-> Since case sensitive is set to True the key us didn't match with the key US in the dictionary, the default value Value not found is returned.
Last updated