Status
Tech review

Style guide




Short description

Returns a number or text value in value_list that is in the same position as key is in key_list.

Output

Available since




Supported list types


Number list

This function returns the numeric value in value_list that is in the same position as string 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  is in position count(key_list) + 1.


getMatchingValue(string key, string list key_list, number list value_list) #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



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_list is a number list. 


getMatchingValue(string key, number list key_list, number list value_list) #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