IronPython Script to remove rows based on criteria

[Vincent Thuilot 2]

Hello

I would like to run a script which is removing rows from a table based on a column called "UserCheck" generated via a transformation.

Here is the script:

_________

from System import Environment, Threading

username = Threading.Thread.CurrentPrincipal.Identity.Name

Document.Properties["username"] = username

from Spotfire.Dxp.Data import DataValueCursor,RowSelection,IndexSet

from System import Convert

myTable=Document.ActiveDataTableReference

Userlist=[]

Userlist=DataValueCursor.CreateFormatted(myTable.Columns["UserCheck"])

RowCount=myTable.RowCount

rowsToFilter=IndexSet(RowCount,False)

for row in myTable.GetRows(Userlist):

if ["UserCheck"]"Yes":rowsToFilter.AddIndex(row.Index)

myTable.RemoveRows(RowSelection(rowsToFilter))

__________

For the moment it is removing every rows and I can't make it only removing rows for which the column 'UserCheck" is not"YES"

Any idea

 

Thanks a lot

Vincent

[Shandilya Peddi]

Hello Vincent,

 

Replace your IF condition withthe following line of code and this should fix your issue,

 

if Userlist.CurrentValue"Yes":rowsToFilter.AddIndex(row.Index)

[Hector Martinez 2]

You could always just use this if you want to simplify your code ....

rowSelection = myTable.Select([userCheck]"Yes" )

myTable.RemoveRows(rowSelection)