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

Avatar

Avatar
Validate 1
Level 1
jael39132526
Level 1

Likes

2 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
jael39132526
Level 1

Likes

2 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
jael39132526
Level 1

14-12-2018

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?

Accepted Solutions (0)

Answers (0)