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

"Group By" Temp Schema Data - Workflow

Avatar

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

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

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidh2892249
Level 3

06-09-2017

Hi

I regularly make use of a workflow query and group/count the results by:

* Adding Data

* Adding the output column i'm interested in (and select "group" box)

* Adding another output column and using the count(@id) expression.

* On advanced parameters removing duplicate rows and disabling the automatic adding of primary keys of the targeting dimension.

I was looking to do something almost similar, but instead of using a query, I wanted to group by some temp schema data (because i need to make use of other activities to get it how i want before grouping).

When using enrichment, I again add data and select the output columns:

1) field i'm interested in getting counts on (ticking group box)

2) count expression

* On advanced parameters removing duplicate rows

However the option to select "Disable the automatic adding of primary keys of the targeting dimension" option is not available.

The enrichment activity therefore errors.

Can anyone advise if there is a setting i am missing or an alternative approach to group/count temp schema data

Thanks in advance

David

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

18-09-2017

Hi David,

Alas!! This option is not possible in enrichment although there is a workaround.

Feed enrichment or any temp results to a query activity and use group By like a standard query in there. Refer to this screen for reference. It's simple and easy to implement.

1301212_pastedImage_0.png

If you need more details let me know.

Regards,

Amit

Answers (6)

Answers (6)

Avatar

Avatar
Boost 1
Employee
julienf3843431
Employee

Likes

2 likes

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Employee
julienf3843431
Employee

Likes

2 likes

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile
julienf3843431
Employee

18-09-2017

Hi David,

(I just saw an answer has been posted but I'll post mine anyway )

The option Disable the automatic adding of primary keys of the targeting dimension is not available in your case because you're on a temporary schema which (may) have no target dimension so no automatic primary keys.

However, if I understand your use case correctly, it should be possible to do what you want to achieve by unchecking the option Keep all additional data from the main set (in enrichment tab on the main screen of the enrichment activity).

Then, you can add your group by expression and the count expression (you could use countAll() function which is actually an COUNT(*) in the SQL way).

Hope it helps.

Regards,

Julien

Avatar

Avatar
Validate 1
Level 1
cbeattie1992
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
cbeattie1992
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
cbeattie1992
Level 1

15-11-2018

Hi Julien,

I think this is more along the lings of what i am looking for.

I will to count the ID's grouped by the Values and Name of the field.

There are several different fields which i am try to count here.

I have unchecked the 'Keep all additional data from the mail set' and it is not giving me an error. However i only have a count of 0.

Am i doing anything wrong?

Thanks so much

Connor

1622296_pastedImage_0.png

Avatar

Avatar
Validate 1
Level 1
cbeattie1992
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
cbeattie1992
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
cbeattie1992
Level 1

15-11-2018

Hi Amit,

I am really interested to know more about this solution.

Can you please go into more details as i am not sure how this works?

Thanks a lot

Connor

Avatar

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

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

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidh2892249
Level 3

18-09-2017

Thanks Amit,

This is perfect, always a workaround - just need to know them

Thanks Again

David

Avatar

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

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

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidh2892249
Level 3

18-09-2017

Hi Florent,

Thanks for picking up, this would be very useful to know as I could see me using it in many scenarios.

Thanks

David

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

15-09-2017

Hi David,

I'll forward your question to one of our data management experts. I hope to get a reply soon. I know this kind of actions can be a bit tricky, especially with the enrichment activity. Please let us know if you find a way in the meantime.

Florent