How to set dynamic urls for a column in a table visualization?

[Prateek Rawat 3]

Is it possible to set urls dynamically in a spotfire table visualization?

I have a column A and I want to make it a link using the link under renderer property.

Issue is that I don't just want to pass the value of column A as a parameter but there is one more parameter that is required before the column A value:

For example:

https://community.spotfire.com/abcd/{value of column A}

in the above url the value of column A is dynamic, but I want abcd to be dynamic as well, because in my case it is different for different values of column A.

So, is it possible to pass 1 more dynamic parameter apart from just the values of column A?

Or is there any workaround?

[Gaia Paolini]

I presume you mean {value of column A} as a document property?

It should be possible to do https://community.spotfire.com/{value of abcd}/{value of column A}

Have you tried and it did not work?

[Prateek Rawat 3]

Yes. I did try it , but it did not work.

[Gaia Paolini]

OK, yes I see that the label renderer only feeds from a single column.

You could create a new column that is a combination of the folder and the image?

Something like:

[combined_column]: Concatenate([folder_column],'//',[image_column]')

then your renderer could still be

https://blahblah//{$}.jpg

where $ is your[ combined_column]?

[Prateek Rawat 3]

Problem with this approach is that the values displayed in the table visualization will also be a concatenation and business does not want that.

Is there any other solution to this?

Can it be achieved programmatically using ironpython or a data function?

[Fredrik Rosell]

Hello,

To my knowledge there is no way to achieve that (I have tried to solve a similar use case myself). It's part of a very popular idea in the Ideas portal - https://ideas.tibco.com/ideas/SPF-I-852 - that I really want to encourage you to vote for as every vote increases the chance of it being implemented. As there are several overlapping ideas (ability to control the display value, ability to build the link on values other than the exact column value), make sure to comment on your particular needs.

In my case, I ended up simply using the method Gaia mentioned - a calculated column - accepting that the value displayed was not exactly what I wanted.  

However, one approach (which would not work exactly like the table plot links though) might be to use the Custom DateTime Data function, which allows you to e.g. run an IronPython script when the user marks something in the plot.

Custom DateTime Data Function for TIBCO Spotfire®

https://community.spotfire.com/s/article/Custom-DateTime-Data-Function-for-TIBCO-Spotfire

In the IronPython script, you can now build the URL from the marking (value in column A) and your abcd value etc. To make sure that you solution works in Web Player (I assume you want that), you could look at the following example:  

How to open a URL in TIBCO Spotfire® Using IronPython Scripting

https://community.spotfire.com/s/article/How-to-open-a-URL-in-TIBCO-Spotfire-Using-IronPython-Scripting