Re-order a general list alphabetically

Joelarkins
Joelarkins
in Modeling

Hi,

I'm trying to re-order a general list into alphabetical order. Its a hierarchal list and I'm not sure what steps to take. The list is a dimension for many modules and performs as a drop down menu for UX pages. Any guidance on this would be appreciated!

Thank you

Joe

Answers

  • andrewtye
    andrewtye

    Hi @Joelarkins - if you add a text line item into the hierarchy's system module and have as the formula name(item([list name])) or the use the display name field if it's a numbered list and then create a sort action using that list.

    This used to be only actionable by workspace admins - not sure if end users can now run this update.

    It's a handy action to run after you've updated any hierarchy

  • SriNitya
    SriNitya
    edited February 13

    Hi
    Using reorder action, you can achieve it.
    If the list is numbered list use display name to sort alphabetically and if list is general list use List item Name to reorder. Upon running the action created the data gets ordered and wherever the list is used it will be displayed alphabetically
    Hope it helps.

  • Joelarkins
    Joelarkins

    Thanks both,

    Using the reorder action is my preferred route but the 'select line item' is confusing me. I'm not sure what role this is playing? In my mind, all I would need to select is the list to order alphabetically and in what way. Heres a screenshot…

    image.png
  • SriNitya
    SriNitya

    Select Line item → You need to select the line item with which you want to reorder the list.
    If the list is numbered list use display name to sort alphabetically and if list is general list use List item Name to reorder

  • devrathahuja
    devrathahuja

    Hi @Joelarkins ,
    You need a line item with a number count for it to be able to sort the list in any order.

    Create a new line item using rank to rank the list members alphabetically & use that to reorder the list.

    You can either follow this approach for the rank - https://community.anaplan.com/discussion/23274/how-to-rank-by-text-line-item

    OR create another list with A-Z and have the codes as 1-26, then you can take the first alphabet of your list member's name have it converted to a number using the above & rank it.

    Hope this helps! :)

Categories