Status
Tech review

Style guide




Short description

Returns a custom reference value for a given or text or number. 

Output

Available since




Supported list types


Number list

This function returns the numeric reference value 


getMatchingValue(key, keyList, referenceList) #Output: number



Parser expressionDescription


getMatchingValue("Three", ["One", "Two", "Three", "Four", "Five"], [1, 1+1, 3*1, 4, 4+1])


This example returns the number 3


getMatchingValue("Critical", ["Normal", "High", "Critical"], [1, 5, 20])


This example returns the number 20



Parameters used in this function

ParameterInput (data type)Description
key

A text that exists in the keyList.
keyList

Any given text list.
referenceList

Any given number list.



This function returns a .

If the key is not in the keyList, the function returns .




Variant with 2 number lists.


getMatchingValue(key, keyList, referenceList) #Output: Number



Parser expressionDescription


getMatchingValue(5, [1, 3, 5, 7, 9], [1, 1+1, 3*1, 4, 4+1])


This example returns the number 3



Parameters used in this function

ParameterInput (data type)Description
xxx

Parameter description.
xxx

Parameter description.
xxx

Parameter description.



This function returns a



Text list

This function returns a text value in value_list that is in the same position as text key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list then, the element of value_list in position count(key_list) + 1 .


getMatchingValue(string key, string list key_list, string list value_list) #Output: Text



Parser expressionDescription


getMatchingValue("Spain", ["USA", "UK", "France", "Spain", "Germany"], ["Washington", "London", "Paris", "Madrid", "Berlin"])


This example returns the following text: "Madrid"



Parameters used in this function

ParameterInput (data type)Description
xxx

Parameter description.
xxx

Parameter description.
xxx

Parameter description.



This function returns a




Variant where argument key is a number and argument key_list is a number list.


getMatchingValue(number key, number list key_list, string list value_list) #Output: Text



Parser expressionDescription


getMatchingValue(8, [2, 4, 6, 8, 10], ["Washington", "London", "Paris", "Madrid", "Berlin"])


This example returns the following text: "Madrid"



Parameters used in this function

ParameterInput (data type)Description
xxx

Parameter description.
xxx

Parameter description.
xxx

Parameter description.



This function returns a