Attempting to aggregate / count values from a temporary table

Avatar

Avatar

cbeattie1992

Avatar

cbeattie1992

cbeattie1992

27-07-2018

Hello,

I am trying to count of Number of Customer Contact Rule ID's per Contact Rule grouped by Name and Value from with a temporary table which i have created
with the workflow.

The number of Customer Contact Rule ID's per Contact Rule within the temp table have already under gone some deduplication criteria before getting to the aggregate stage in the workflow. Therefore i wish to count the total of Customer Contact ID's within the temp table.

Grouped by 2 values:

  • Contact Rule Name (Customer ContactTable)
  • Customer Contact Value (Contact Rule Table) - Different tables

I can count the number of Customer Contact Rule ID's when looking at the linking using the add data function: Data Linked to filter dimension. However this of course returns the total number of product id's with no reference to the population within the temp table.

When i select the criteria within the enrichment: Data of the filtering dimension.  I proceed to count on the Id's from the temp table and then group on the 2 values.

1536776_pastedImage_10.png

Then i checked the advanced parameters box 'Group by targeting dimension'

1536777_pastedImage_11.png

However i continue to the follow error message:

'must appear in the group by clause or be used in an aggregate function'

I believe this might be due to the fact that i am grouping on values within the temp table - but are group different tables?

Please any help around this would be fantastic,

thanks a lot

Connor

View Entire Topic

Avatar

Avatar

Debabrata_T

Avatar

Debabrata_T

Debabrata_T

10-07-2019

Hi,

Can You try uncheck "Keep All Additionla Data from main Target" in enrichment.

Regards,

Deb