Transform two arrays into a map where the first array is the key and the second is the value

Question

Hi, 
 I am parcticing with the a!queryRecordType() function and I realized in return one field called identifiers where the primiary key is returned and I would like to know if I could transform it together with the data field into a map where the identifiers values are the keys and the data values are the values. 
 For example: 
 Having: 
 identifiers : {12,20} 
 data : {"first value", "second value"} 
 Transform it into 
 {12: "first value", 
 20: "second value}

Konduru Chaitanya · Accepted Answer

Hello antoniochl , 
 Please refer the below code. I hope this will help. a!localVariables(
 local!identifiers: { 12, 20 },
 local!data: { "first value", "second value" },
 {
 append(
 a!forEach(
 items: local!identifiers,
 expression: concat(
 fv!item,
 ": ",
 index(local!data, fv!index, null)
 )
 )
 )
 }
)

can you also try this, 
 a!localVariables(
 local!identifiers: { 12, 20 },
 local!data: { "first value", "second value" },
 {

 a!flatten(
 a!forEach(
 items: local!identifiers,
 expression: {
 a!map(
 identifier:fv!item,
 data:index(local!data,fv!index,null)
 )
 }
 )
 )
 
 }
)

Mathieu Drouin · Answer

Here's a way to do it that doesn't require the Dictionary Manipulation plugin. Note that the keys cannot key integers, they need to be Strings (hence the cast). 
 a!localVariables(
 local!keys: { 12, 20 },
 local!values: { "first value", "second value" },
 local!keyValues: a!forEach(
 items: local!keys,
 expression: a!map(
 key: fv!item,
 value: index(local!values, fv!index, null)
 )
 ),
 a!update(
 a!map(),
 cast(typeof({ "" }), local!keyValues.key),
 local!keyValues.value
 )
)

Laurens Weijzig · Answer

In this way you would duplicate the data you already have into another process variable. That is not memory efficient. 
 
 Alternative to your solution you could: 
 - Create an expression that returns the requested value based on rule inpuds: 1/ given id and 2/ data array (originating from your a!queryRecordType()). 
 - Just query single item on given ID. Create seperate expression rule and set as script task data output in your PM. 
 Both produce re-usable components that make sense when building an Appian application.

Transform two arrays into a map where the first array is the key and the second is the value

Top Replies