删除/删除或隐藏在Spotfire中的列(Remove/ delete or hide column

2019-10-19 05:03发布

如何删除/删除或Spotfire中使用铁脚本隐藏列?

对于添加一列我做了如下:

`

curDT = Document.ActiveDataTableReference
cols = curDT.Columns
# targetCol = Document.Properties["myColumnSelection"]

#Create a new column that counts the comma delimiter
myExpression = '1+len(RXReplace([Cx],"([A-Za-z0-9]+)","","g"))'
myNewColName = cols.CreateUniqueName("NumElements")
cols.AddCalculatedColumn(myNewColName, myExpression)

`

Answer 1:

如果它仍然是有帮助的:

from Spotfire.Dxp.Application.Visuals import VisualContent
contentTable = myTableVisualization.As[VisualContent]()
if contentTable.TableColumns.Contains(myData.Columns["MyColumn"]):
        contentTable.TableColumns.Remove(myData.Columns["MyColumn"])


Answer 2:

通过删除列

cols.Remove( “NameOfColumnToRemove”)



文章来源: Remove/ delete or hide column in spotfire