I am trying to filter out rows from a data table where the Order_ID is NOT EQUAL to an Order ID extracted from a PDF document which I will be storing in a string variable eg. “OrderID”.
I have tried everyway to do this with the Filter Data Table, however it just keeps making a partial match and then returning rows even where a few characters match the “OrderID” variable, if someone could recommend a way of doing this using the Filter Data Table that would be much appreciated.
However I have managed to do this with Remove Data Row, however I cannot select into “filteredList” (Array of Data Rows), based on “OrderID”.
Please see workflow. I need to change:
transactionsDT.Select(“Order_ID <> ‘CLS-178-4486’”)
the text ‘CLS-178-4486’ is the Order ID which is supposed to be a variable “OrderID”, how would I write this?, what is the syntax?, I am really baffled something this simple looking is taking all day.
Main.xaml (6.4 KB)