Adobe Campaign Standard Direct Mail - how to order the output by a given specific field | Community
Skip to main content
C
Cogs
Level 2
January 13, 2022
Solved

Adobe Campaign Standard Direct Mail - how to order the output by a given specific field

  • January 13, 2022
  • 1 reply
  • 862 views

Hello all. We have a requirement to be able to sort our mailing output by account number - so as to better see the joint accounts (with two rows) and make checking mailing proofs much easier. We don't want to filter out any rows just change the order of the output.
I can see there are "windowing" or representation functions such as Desc and OrderBy but I get error messages about invalid aliases when trying to use them on the account number field and I suspect they might be meant to generate QUALIFY SQL statements and so might not be what I want directly...

I have looked at the docs and searched here but could find no solution. Does anyone have the answer to produce a simple ORDER BY?
PS: The answer does not have to in the direct mail step but those windowing functions could help and don't appear elsewhere that I have seen

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

in the direct mail dialog where you choose the columns to be exported, you do have a "sort on extracted data" panel at the bottom. Expand it and add the account number there for getting a sorted export file

1 reply

B
Adobe Employee
bisswangAdobe EmployeeAccepted solution
Adobe Employee
January 14, 2022

in the direct mail dialog where you choose the columns to be exported, you do have a "sort on extracted data" panel at the bottom. Expand it and add the account number there for getting a sorted export file

    Terms & ConditionsAccessibility statement

    Loading footer...