Map with variable key

Question

Is it somehow possible to create a map or dictionary using variables for the keys? For example, is there some way for me to do something like a!map(localvar1:local!var2) to make a user generated map? Or maybe use a foreach loop over a 2d array to convert it to a map?

Alex Boerescu · Answer

Hi, I know it's late, but I thought it'd be good to capture the response here. 
 You could use reduce with merge to achieve the desired outcome - not sure if all functions were available at the time you asked. 
 a!localVariables(
&#160; local!keys: { "keyOne", "keyTwo", "keyThree" },
&#160; local!values: { 117, "Appian", now() },
&#160; reduce(
&#160; &#160; a!update,
&#160; &#160; a!map(),
&#160; &#160; merge(local!keys, local!values)
&#160; )
) 
 Kudos to Dionne OBrien for the coming up with the solution!

Chris · Answer

AFAIK there isn't any way to define the key within a!map() dynamically like this. This sounds like a situation I would utilize the database to maintain dynamically defined key-value pairs, where the user can enter both and you can reference them where you need via a!queryEntity(). 
 What is the use case?

ajhick · Answer

Hi Marco, 
 The only way I've found of doing this is utilising JSON. Is below sort of what you're looking for? 
 a!localVariables(
 local!keys: {
 "keyOne",
 "keyTwo",
 "keyThree"
 },
 local!values: {
 117,
 "Appian",
 now()
 },
 local!keysAsJson: concat(
 "{",
 a!forEach(
 items: local!keys,
 expression: concat(
 char(34),
 fv!item,
 char(34),
 ":",
 char(34),
 char(34),
 if(
 fv!isLast,
 {},
 ","
 )
 )
 ),
 "}"
 ),
 local!keysAsDictionary: a!fromJson(local!keysAsJson),
 reduce(
 a!update,
 local!keysAsDictionary,
 merge(
 local!keys,
 local!values
 )
 )
)

Map with variable key

Top Replies