I am trying to filter a data table to remove rows which contain specific elements (contained in variables and text).
Simply put, this is not working; is there something I am doing wrong or missing to do this? The items in the ‘value’ section should be what the rows contain.
Perhaps I need to name the column something different? I don’t know how I would rename a column header…
I was going to run it again to get an example, but now it is saying ‘Filter Data Table: the value for argument ‘ColumnIndex’ is not set or is invalid.’
In addition to the Or logic as @Anil_G mentioned, I observe that you use the index 0 to point to your target column. I would suggest you use a declarative approach by specific the ColumnName instead of ColumnIndex.
But why?
Ensures the code is interpret by others who will have to maintain your code
In the future, if the index of target column for some reason changes within your datatable, a declarative approach will only look for the correct ColumnName , this will ensure your code is robust to future changes.
That issue was that it didn’t scrape properly to cause that. Column 0 is more reliable than a name should that change, this table is not my own and so I don’t control any changes.