Sorting data in workflow

[LAR1985]

Hi community,

We have a workflow and we need to sort the records that come out of an exclusion node by a numeric field in order to assign them a value in a new field according to the order of each record using the rowId() function. How can we sort them? We are unable to find any sort functionality.

Thanks in advanced

[Craig_Thonis]

Hi LAR, 

While there isn't any sort control within the Exclusion activity, have you tried including some sort of sort logic further up in your workflow?

If you need to assign values based on a numeric field “in order”, some options are:

1. Move the sort logic to another activity:

   • Persist the population produced by the Exclusion (e.g. via an Update data flag or a custom resource).
   • Use a Query/Enrichment afterwards to re‑select those records and apply deterministic logic based on your numeric field (e.g. bucket by ranges).

2. Avoid rowId() and derive the category directly from the numeric value (for example score <= 10 → group A, score <= 20 → group B, etc.), so you don’t rely on record order at all.

3. If you truly need 1, 2, 3, … ranking by a field, you’d have to compute that rank outside ACS (or in a JS/SQL context in Campaign Classic/v8) and then bring it back into ACS as a normal field.

Best regards,

Craig