Spotfire Client: Dynamic concatenation of columns using Document Property

This article gives overview of how to dynamically concatenate multiple columns in a calculated column using document properties and the List box(multiple select).  

• Create a text area and insert a List box(multiple select) document property. 
• Select the columns you want to have in the List box for Concatenation and click OK.
• Now insert a calculated column and put the following expression in it.

case 
when Find("_","$map("[${example}]", ",'_',")")>0 
THEN
Concatenate($map("[${example}]", ",'_',"))
ELSE 
NULL
END

 Here, ${example} is the name of the document property created. 

This expression will concatenate the columns with an underscore in-between. 

If you want to concatenate them with other character, you can replace the underscore with that character. 

If a single column is selected, then the value will be NULL.