displaying constant array values in grid columns

Question

I have a grid column which displays numbers ( from the view and then data subset ) . But I want to display texts correcsponding to these numbers 
 
 Currenly its displaying 
 
 {1 , 2 , 3 , 4 } 
 
 I want to display correspondingly if 1 then Root 1, 2 then Root 2 .. etc 
 
 { Root 1 , Root 2 , Root 3 ,Root 4 } 
 
 So i created a constant array ROOT_TIER_VALUES and stored { Root 1 , Root 2 , Root 3 ,Root 4 } 
 
 Now when i create the grid , as a result of index , i get either 1,2,3, or 4 . i changed as per "My change " , but it is not working . Can we use apply for the scenario below ? 
 Original 
 a!gridTextColumn( label: "Root Tier ", field: "rootId", data: index( local!dataSubset.data, "rootId", {} ) , alignment: "RIGHT" ), 
 
 My Change : 
 a!gridTextColumn( label: "Root Tier ", field: "rootId", data: cons!ROOT_TIER_VALUES[index( local!dataSubset.data, "rootId", {} ) ], alignment: "RIGHT" ),

Justin Watts · Accepted Answer

Yes, this is an appropriate use case for apply() or a!forEach(). This SAIL recipe shows a few examples of manipulating data in grid columns in this way - docs.appian.com/.../recipe_show_calculated_columns_in_a_grid.html

Abhay Giri · Answer

Hi Ramanan, 
 
try the below code 
 
a!gridTextColumn( 
 label:"Root Tier ", 
 
 data: a!forEach( 
 items: local!dataSubset.data, 
 expression: 
 concat(cons!ROOT_TIER," ",fv!item.rootId) 
 ) 
 ) 
 
in your constant only store Root and it should not be array type. I hope this will help you. 
 
Regards 
Abhay Giri