Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Record count mismatch

jael39132526
Level 2
Level 2

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:

count mismatch.png

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

null values.png

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.

use split.png

pk not null.png

Any other suggestions?

0 Replies