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

Count of records in a table

Avatar

Avatar
Level 1
whalen1618
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
whalen1618
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
whalen1618
Level 1

30-03-2020

I'm looking for some help in getting counts for records in Campaign.  I have an external transactions database that I'm querying as the target and filtering dimension.  Within the table is a field (MemberID) that can be duplicated across multiple transactions, so after I have the transactions returned that i'm looking for, I want to have a count of the number of times the Member ID appears.  Example:

TransactionID (Key)MemberID
111111
222222
311111
422222
533333

 

I want to get a count of the number of times the MemberID appears, but I'm having issues because the MemberID is not a key.  I have no problem doing counts other times with counts related to the table keys, but I'm lost on this one.  I'm looking for results like:

 

Member IDCount of MemberID
111112
222222
333331

 

Any help would be greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

383 posts

Correct Reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

383 posts

Correct Reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

01-04-2020

Hi @whalen1618 ,

 

click on Advanced Parameters and select option Disable automatic adding of primary keys of the targeting dimension and that will work for you. Needed only when you do aggregation which does not include primary key.

 

Regards,

MIlan

 

Answers (0)