concat data in in grid

Question

Hello i am french and beginner on appian. 
 I want to retrieve a list in a grid. 
 My problem is that I want to concatenate 2 data (from query) in a single column of this grid. I tried : a!gridTextColumn( label: "Client", data: concat(index(local!listofreclamations.data,"FirstName",{}), index(local!listofreclamations.data, "LastName", {})) ), 
 But all indexes are concatenated on a single line. Can you help me ? Thanks

aloks0189 · Answer

Hi lindab0001 As per my understanding, you are having multiple FirstName, and LastName where you want to concat FirstName and LastName of the same index together. 
 If so, you can make the use of a!forEach() function, where the item will be local!listofreclamations.data, for example, i can take a normal use case 
 
 load(
 local!listofreclamations : todatasubset({
 {FirstName: "A", LastName: "B"},
 {FirstName: "C", LastName: "D"},
 }),
 a!forEach(
 local!listofreclamations.data,
 concat(fv!item.FirstName, " ", fv!item.LastName)
 )
) 
 Assume, here local!listofreclamations contains your actual data in the form of datasubset. So try holding this looped value into a local variable and use this for gridTextColumn 
 
 Hope this will help you.

Vinay Kumar Rai · Answer

Use apply function:

a!gridTextColumn(
label: "Client",
data:
if(
local!listofreclamations.totalCount = 0,{},
apply(
concat(_," ",_),
merge(
index(local!listofreclamations.data,"FirstName",{}),
index(local!listofreclamations.data, "LastName", {})
)
)
)
)

concat data in in grid

Top Replies