How to order by a result set in Query activity?

1 reply
1907 views
Translate All

Hi Dear Team,

I need make a query result set been order by some column, but I did not find any configuration about this. Please show me how to achieve this ?

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

ParthaSarathyAccepted solution

Community Advisor

Hi @yueminspb ,

By default it will be ordered by primary key. To order by specific column (Say, First name), You can place split activity next to query, and you can configure split activity as below to get ordered result.

Limit the selected records > Keep only first records after sorting > Select your column and select descending or ascending sort > And in Limits, select size in % as 100 > Finish.

Regards,

ParthaSarathy S

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

ParthaSarathy

Accepted solution

Community Advisor

Hi @yueminspb ,

By default it will be ordered by primary key. To order by specific column (Say, First name), You can place split activity next to query, and you can configure split activity as below to get ordered result.

Limit the selected records > Keep only first records after sorting > Select your column and select descending or ascending sort > And in Limits, select size in % as 100 > Finish.

Regards,

ParthaSarathy S

Translate

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Sign up

Login with SSO

Login to the community

Login with SSO