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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

Record count mismatch

Avatar

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