google sheets query returning returning a row with empty cell even though condition checks for null

Question

I am working on a workflow process in the sheet below https://docs.google.com/spreadsheets/d/1MS-UydJ9EJ_jOrSwSt1o4Lh6ekGQxpsprFz2RAq6CdI/edit?usp=sharing

I am facing an odd issue. In the DataStudio sheet i have a query which checks the actual and planned columns in the FMS sheet and should not return any results where the planned column is null. In the current sheet it is returning one row where the planned column is blank. To check this I queried the specific range in FMS in Sheet35 with the query in cell G1

=query({FMS!B8:B,FMS!U8:V},"select * where Col2 is not null")

this is returning a row where Col2 is blank and should not pass the condition is not null. I dont know if I am missing something very fundamental here as I even as a check tried to set the cell to IFERROR(0/0) which should return a blank and that still shows in the result

player0 · Accepted Answer · 2021-01-30 18:34:58Z

1

try:

=QUERY({FMS!B8:B, FMS!U8:V}, "where Col2 is not null", 0)

answered Jan 30, 2021 at 18:34

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

google sheets query returning returning a row with empty cell even though condition checks for null

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related