Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Dynamic concatenation of columns using Document Property
Solution:
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).
- 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.
Comments
0 comments
Article is closed for comments.