Dynamic concatenation of columns using Document Property
book
Article ID: KB0081333
calendar_today
Updated On:
Products
Versions
Spotfire Server
7.5 and higher
Description
This article gives overview of how we can dynamically concatenate multiple columns in a calculated column using document property. Here, we will have to use List box(multiple select).
Resolution
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 we created. This expression will concatenate the columns with underscore between them. 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. Refer the attached analysis file for reference.
Issue/Introduction
Dynamic concatenation of columns using Document Property
Attachments
Dynamic concatenation of columns using Document Propertyget_app