Datatable select not equal issue



Hi, I have a issue

Dt =" [COLNAME] <> ‘Exception’ ").copytodatable
but it keeps throwing me source contains no datarows when there should be a lot of rows with empty or whitespace values


@inyourgravity can u share screenshot of that column?


Unfortunately it consist sensitive data and is on my client’s computer.
I did however get it to work with [Colname] is null.


Try to use filter data table activity instead