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

SOLVED

Use of Sub-item option inside Query activity

jael91407431
Level 3
Level 3

Can anyone give an example of how one would use a sub-item inside the Add data/edit additional data option the query activity?

subitem.png

As per Adobe's documentation, the add sub-item option lets you attach computed data to the collection. This lets you select the additional data from the collection or define aggregate calculations on collection elements.

Can anyone give use case examples?

1 Accepted Solution
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

Hi,

Most of the time when you define aggregate calculations you have to disable the primary key addition to use group by clause otherwise group by will not work as all rows will be unique because of primary key so we create aggregate and use a 1-1 link to add this back to main target query. Now you have everything i one query and you are all set for the final send out.

for use case please refer to this link:Using aggregates

Regards,

Amit

View solution in original post

3 Replies
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

Hi,

Most of the time when you define aggregate calculations you have to disable the primary key addition to use group by clause otherwise group by will not work as all rows will be unique because of primary key so we create aggregate and use a 1-1 link to add this back to main target query. Now you have everything i one query and you are all set for the final send out.

for use case please refer to this link:Using aggregates

Regards,

Amit

View solution in original post

florentlb
Level 10
Level 10

Hi,

In addition to Amit's comment, you can check this example here: Synchronizing audiences​ (in the context of sharing lists with ACS, but the principles remain the same for additional data)

Florent

jael91407431
Level 3
Level 3

Thank you so much. Will check it out for sure, and post any additional questions I may have.