Datatable select not equal issue

studio

#1

Hi, I have a datatable.select issue

Dt = dt.select(" [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


#2

@inyourgravity can u share screenshot of that column?


#3

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


#4

Try to use filter data table activity instead