Dynamic concatenation of columns using Document Property
Article ID: KB0081333
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).
Issue/Introduction
Dynamic concatenation of columns using Document Property
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.
Attachments
Feedback
Yes
No
Powered by
