Dinamically change the column name in a custom expression using $map in Spotfire

[Roberto Sichera]

I have a property that contains a list of column names and I want to create a custom expression using the $map function, something like this

$map("Sum(${myproperty}) as [${myproperty}]", ",")

However, I would like to change the column names dinamically when they contain a given string.

I have tried the following, which however doesn't work as it returns the expression between []

$map("Sum(${myproperty}) as [if(Find('string',${myproperty}),'new name', 'old name')]"), ",")

I have also tried the following, but it seems that $map() does not accept Concatenate()

$map(Concatenate("Sum(${myproperty}) as [",

if(Find('string',${myproperty}),'new name', 'old name'), "]"),

",")

Is it possible to realize what I am trying to do in Spotfire

[Gaia Paolini]

can you show an example of the content of myproperty

[Roberto Sichera]

myproperty contains a list of column names, e.g Col1, Col2, Col3

 

As  I trigger an action through a button, I managed to solve my problem by creating a new property containing the new column names and change this property by an IronPython script.

 

In this way I can use the custom expression:$map("Sum(${myproperty}) as [${myotherproperty}]", ",")

 

However, I wonder if it would be possible to do the same thing without using an IronPython script.

[Gaia Paolini]

I am guessing this document property containing the list of string names is of type stringlist (otherwise, if it is already a comma separated string, I don't think you need $map).

I am not sure where you want to put this custom expression, so I am creating a calculated column with it. In the attached example there is a document property called myprop that is a stringlist, populated via a multi-select choice on the left of the page.

A calculated column called test1 concatenates this stringlist into a comma separated string:

'$map("${myprop}",",")'

A calculated column called test2_withSubstitution does the same but adds a substitution (Cat to Dog):

RXReplace('$map("${myprop}",",")','Cat','Dog','g')