I have a CSV file that is read into a datatable. The CSV has no headers so the datatable generated generic headers of Column1,Column2,…,…
Here are a couple of the records being read in:
I am trying to use the FilterDataTable activity to keep only rows which are >= 200 in Column7 and > 1 in Column5 which both the above examples are.
The resulting datatable is empty which I can only assume is because those columns are being recognised as a string rather than a number, so the greater than check doesn’t work.
Any suggestions on how to overcome this issue?