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
Discussion posts and replies are publicly visible
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.
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", {}) ) ) ) )