Is it possible to write a group by conditions in PQL for audience rule?

[ShashiCh]

Is it possible to write group by OR nested group by in PQL queries for an audience evaluation? If yes, What is the syntax?

Profile ID	Ranking	DateofBirth
1	1	01/01/1980
2	1	02/02/1981
3	2	03/04/1982

Condition

• If Ranking score is same, Pick one profile by Max Date of birth
• If Date of birth is same, then pick one random profile

End result

Profile ID	Ranking	DateofBirth
1	1	01/01/1980
3	2	03/04/1982

[AnanthanJa · Accepted solution]

Hi @ShashiCh,

PQL by definition works on individual profile-level data and not at a dataset level.

However, what you are referring to is sorting the data at a dataset level and then applying data split. Hence pql will not be able to support it.

You can consider using a data distiller to create a new dataset and mark attributes based on the split that you require. In simple words, you can use SQL expressions for the same. 

You can also consider using Rank and Split activity inside Audience Composition workflows. Refer to the documentation.

https://experienceleague.adobe.com/docs/journey-optimizer/using/audiences-profiles-identities/audien...

Do check on the guardrails on the number of audience composition workflows that you can create in a sandbox.