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

Require the of different value in a table

Avatar

Avatar
Validate 1
Level 1
Sumit_Saha
Level 1

Likes

2 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
Sumit_Saha
Level 1

Likes

2 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Sumit_Saha
Level 1

20-08-2016

Hi All,

I have an enumeration in a table. There are multiple entry for the different enumerations in the table. Now i want to get the count of record for each enumeration values in a workflow. But I am facing issue in the group by clause where I must add primary key in the group by  condition. bt that defeats the purpose as primary key is unique.

Please Suggest.

Happy Campaigning,

Sumit

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile
Linda_Stinson
Employee

02-09-2016

Hi Sumit,

You need to 'Disable automatic adding of the primary keys of the targeting dimension'.

I have created an example counting the number of residents of each city in the data mart:

Count of enumeration values.jpg 

Here is the result:

Count of enumeration values Result.jpg

Let me know if this is what you are trying to do.

Linda

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
Sumit_Saha
Level 1

Likes

2 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
Sumit_Saha
Level 1

Likes

2 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Sumit_Saha
Level 1

02-09-2016

Linda,

Thanks for the update. But I actually figured removing the primary key functionality in a query activity.

But again thanks for the resolution.

Regards

Sumit