Require the of different value in a table | Community
Skip to main content
Sumit_Saha
Sumit_Saha
Level 2
August 20, 2016
Solved

Require the of different value in a table

  • August 20, 2016
  • 2 replies
  • 1804 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Linda_Stinson

    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:

     

    Here is the result:

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

    Linda

    2 replies

    Linda_Stinson
    Adobe Employee
    Linda_StinsonAdobe EmployeeAccepted solution
    Adobe Employee
    September 2, 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:

     

    Here is the result:

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

    Linda

      Sumit_Saha
      Sumit_SahaAuthor
      Level 2
      September 2, 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

      Terms & ConditionsAccessibility statement

      Loading footer...