Record count mismatch

[jael39132526]

When exporting Broadlog, sometimes counts mismatch:

The starting data from query of the Broadlog yields, 2,029,962 records, but when we export it as a file, we get 2,029,929 records as seen here, a difference of 33 records:

That is because Adobe Campaign counts 'null' values as a row:

How can we eliminate the 'null' values prior to extracting the file, so the counts match?

Thank you.

Follow up:

Since Adobe Campaign defaults "null" values to 0 in PKs, I can use a split to filter counts by @id = 0, or, in the case of empty values (which would show as 'null' and then 0, @id is empty.

Any other suggestions?