I am trying to loop through a table and remove any row that has a column with a specific value. See sample code below. This is not working, what should i be doing and is there a better way? I do not have access to the stored procedures to filter in the query. table = event.source.parent.getCompo…

The easiest way is by using a MutablePyDataSet. Here is the code: table = event.source.parent.getComponent('Table') data = pa.dataset.toData(table.data) rowsToRemove = data.findRows(lambda row: row["ColName"]=="value") data.removeRows(rowsToRemove) table.data = data.toDataSet() “lambda” is Python …

Hi Jerry, Your code will only delete the last row it finds, and if it finds none, return garbage. Also, deleting a row changes the following row numbers, complicating the loop. The best approach is to find all the row numbers you want to delete, then delete them all at once.table = event.source.p…

Thanks pturmel! Had to make a small modification to the code, needed table.data. Below is what worked for me: table = event.source.parent.getComponent('table') data = table.data unwanted = [] for r in range(data.rowCount): if data.getValueAt(r, "column")=="02": unwanted.append(r) newData = s…

[quote=“jerry101”]Thanks pturmel! Had to make a small modification to the code[/quote]Awww, caught posting untested code… :blush: But you’re welcome!

Inductive Automation Forum

Delete Table Row based on column value

General Discussion

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled