Jump to content

Unique Concatenate FILTERED rows from a data table into cross tab title

Brendan Law

Recommended Posts

Using spotfire 7.8. I have a FILTERED data table (I'm using filters on the dataset)like below:


































I would like to create a title for a cross tab vasualization that utilizes the field "CstCtr" to provide a unique string concatenation of all values in the field. The end result title would be:

"ab.123, cd.123"

Is there any way to do this

Link to comment
Share on other sites

Perhaps someone on this forum has a nice expression or way of setting such a title.

If it is not possible to do it in a nice way, one can perhaps do it in a more involved way, by using R scripting (data functions). First, using data function 1, I would create a filtered data table containing the column you want to use (CstCtr), then add a regular calculated column in that intermediary table to get UniqueConcatenate() of that column, and finally, using data function 2, take the first value in that calculated column and put it in a document property which can be set as the title.

This involves two data functions, and thus may be a bit more involved than you were looking for. But it does seem to work. (Tried in Spotfire 7.14.)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...