Spotfire change table source, columns on button click

[Geo G]

I have a table visualization and want to change the data source to it at the click of a button. Also, want to be able to select the columns to be displayed . Can this be done using a script

[Shandilya Peddi]

Hello George,

You can use the below script to change the data source of a TablePlot and also select the columns

 

from Spotfire.Dxp.Data import *

from Spotfire.Dxp.Application.Visuals import *

from System.Collections.Generic import List

 

#Different Data Tables

table1=Document.Data.Tables["table1"]

table2=Document.Data.Tables["table2"]

 

#list of Column to add

listofColumns=List[DataColumn]()

for column in table1.Columns:

#excluding column "columnName" from the list

if column.Name!="columnName":

listofColumns.Add(column)

#Add a script parameter "table" referring to the TablePlot visualization in the analysis

tableVis=table.As[TablePlot]()

tableVis.Data.DataTableReference=table1

tableVis.TableColumns.AddRange(listofColumns)

[Geo G]

Thanks ver much.

 

Is it also possible to order the columns via script

 

How about color coding

[Vishakha Mujoo]

Please register for 10th Oct Dr spotfireOffice hours for an alternative solution

[Mohd faizal Adris]

How can I clear the current table plot column