Trying to concat multiple strings
Hii, I am trying to concat multiple strings
a!localVariables(
local!data:{
a!map(id:1,visitorId:11,name:"John",comment:"hii john"),
a!map(id:2,visitorId:12,name:"Jacob",comment:"hii jacob"),
a!map(id:3,visitorId:13,name:"David",comment:"hii david"),
a!map(id:2,visitorId:14,name:"Bobby",comment:"hii bobby"),
a!map(id:3,visitorId:15,name:"Mark",comment:"hii mark"),
},
local!distinctIds:{1,2,3},
a!forEach(
local!distinctIds,
{
Id:fv!item,
comment:concat(index(local!data,where(index(local!data,"id",null)=fv!item),"name",null)," - ",index(local!data,where(index(local!data,"id",null)=fv!item),"comment",null))
}
)
)
Above code gives me the output as:
Id: 1
comment: "John - hii john"
Id: 2
comment: "JacobBobby - hii jacobhii bobby"
Id: 3
comment: "DavidMark - hii davidhii mark"
But I want output as:
Id: 2
comment: "Jacob - hii jacob"
"Bobby - hii bobby"
Id: 3
comment: "David - hii david"
"Mark - hii mark"
Can anyone fix this?
