how to add another column to the array of dictionary retrieved queryEntity

Question

Hello, 
 I have a local variable which holds the data retrieved by the rule(queryEntity columns). 
 The columns retrieved are Col1, Col2. I want to add Col3 to this. 
 eg. local!QA[1]: [Id:243,value:"Question"] these are the columns retrieved from the rule . I want to add column "Answer" to this. 
 There can be multiple rows. I tried getting the individual row using foreach(), but then idk how to add anothe column to the row. 
 how can i do it?

ranjith.shanmugam · Accepted Answer

Hi Natasha, 
 use the code below 
 a!localVariables(
 local!QA: {
 { Id: 234, value: "Question" },
 { Id: 235, value: "Question" }
 },
 a!flatten(a!forEach(
 local!QA,
 {
 {
 Id: fv!item.Id,
 value: fv!item.value,
 answer: " ANS"
 }
 }
 )
 )
)

how to add another column to the array of dictionary retrieved queryEntity

Top Replies