Create TablePlot visualization using IronPython

[Mohd faizal Adris]

I have managed to create TablePlot visualization using IronPython according to thissuggestion.

What I'm struggling to understand now is how can I clear the TablePlot since I keep receivingan alert message "A table plot column already exists for the data column".

 

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)

[Raghav Rajaram]

To clear the entire table plot, you can use

 

tableVis.TableColumns.Clear()

instead of

 

tableVis.TableColumns.AddRange(listofColumns)

 

If you want to clear individual columns, collect them in a list and run them through a for loop with the following line:

tableVis.TableColumns.Remove(listofColumns)

where listofColumns is the column list and i is the iteration.

 

Best,

Raghav