Empty rows appear in List

Question

Hi, I use a data expression to create the table I use in a list.  However, empty rows appear in the data.  The query is quite a long one, but, explicitly, the filter states it can not have empty rows.

Data is fine and formatted in all the other rows, but these empty ones keep appearing.

Any idea how to get rid of them?

PaulHallett1305 · Answer

Hi Josh

Basically, the filter is

Select * from table where cola = 1

or colb = 1

or colb = 3

or colc = 4

I would expect all 3 rows to return

1  1 4 3

But with below, I would only exlect 1 row returned

1

But I get all 3

jcarlson · Answer

Can you give an example of the data? Is the data filter acting against the same field that's being displayed in the list?

AB1  52

If I filter for "A is not null", but am displaying B in my list, it will look empty.