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
End result
| Profile ID | Ranking | DateofBirth |
| 1 | 1 | 01/01/1980 |
| 3 | 2 | 03/04/1982 |
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.
Do check on the guardrails on the number of audience composition workflows that you can create in a sandbox.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.