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?

ranjiths0003 · Answer

Hi Natasha,use the code belowa!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"      }    }  )  ))

Sign up

Login with SSO

Login to the community

Login with SSO