How to maintain a key value pair in a constant and pick the value by passing the key?

Question

Hi, 
 May I know how to maintain a key value pair values in a constant and refer the constant in an expression rule and pick the respective value by passing the key name. 
 Eg: "72"-"ABC" 
 "75"-"DEF" 
 "80"-"GHI" 
 
 I need to get the value "ABC" by passing "72" as input. Please suggest. 
 
 Regards, 
 Balaji.R

chandu · Accepted Answer

Hi Balaji, Why don't you go with Displayvalue function ? did you ever tried that? 
Please go through the documentation here. 
 docs.appian.com/.../fnc_conversion_displayvalue.html

Nandhavi Nandakumar · Answer

Hi, 
 One suggestion where we can use a constant to solve this. 
 1. We can create a constant of type Text Array and give the values like [key=value] 
 [72=ABC] where 72 is the key, = is the separator and ABC is the value [75=DEF] [80=GHI] 
 Refer Screenshot below 
 
 2. To access these values from a rule, we can use the function keyval() 
 Refer: Link to Documentaion keyval() 
 The following code takes key as input and returns the value: 
 keyval( joinarray( cons!test_keyval, "" ), ri!key, "=", "]" )

ekanshj · Answer

Hi, You cannot use constant for this but instead create a Decision for this scenario. Refer to the screenshot to know how it works.

Sandeep Deshmukh · Answer

Hi rp_balaji , 
 
If you are using latest version of Appian please explore decision object. There are multiple ways of using Key values but I can suggest decision Object. You need to define your Key as input parameter and value as output. 
 
Thanks, 
Sandeep

jims419 · Answer

You could try keyval() function 
 docs.appian.com/.../fnc_text_keyval.html

keyval({"72-ABC","75-DEF","80-GHI"}, {72}, "-") = "ABC"

How to maintain a key value pair in a constant and pick the value by passing the key?

Top Replies