Alphabetize Lists

How can I quickly alphabetize a list?

Accepted answers

Below is a trick that allows you to quickly alphabetize data within the lists (along with their properties).

1. Export the list
2.       Sort the list in alphabetical order
3.       Copy the descriptions
4.       Click the insert dialog box. Paste the descriptions in the list. Change the placement of the object to ‘Start’ and click OK

The data now appears in an alphabetical sort order.

All comments

StefR

PrevContributor

Is there a way to automate this? Perhaps Using Anaplan Connect?

simon_ritchie

Hi Laurence,

I haven't found any good ways to automate this... The above procedure that Stefanie explained is (as I'm sure you know) manual.

I havent tried it but I can see a potential method:[list=1]
Sort list in a module and export all list data (including properties) to a text file
Delete all base items from the list using an Action (Delete from list using selection)
Reimport all items using text output from step 1.
WARNING: Proceed with caution, deleting items in a hierarchy may cause data loss, so I think you would only do that in cases where all data stored against that list is calculated by formulas. That way when item is re-inserted into the list all data will flow in again.
Delete and re-create would also have a large impact on other users if you run it during a busy period, I suggest you run after-hours.

Ping me if you need help setting it up.
Cheers,
Simon

peter_mcanena

There is a way to automate it, using a process. But it involves deleting and reimporting all the list items, which deletes any blue data associated with your list. Is that any use to you?

PrevContributor

You can prevent data loss by mapping all existing properties/line items within the import action that would be part of the process which includes the delete (of course being careful to add new properties to the mapping as new properties are created within the list).

-Chris Weiss

Pat_Desmond

Here's a solution that works in Anaplan without having to export to excel etc. My problem was I needed assumptions entered by Company and the list of Companies was huge and came in automatically out of order through an import.
1) Do a find item on the Company Name list in a module in the source model

2) that Find Item column in the Module CAN be sorted in alphabetical order

3) Saved the view, and re ran the import into the model I needed in and swapped it into the process

Hayk

Hi Stefanie,

In our model it is resolved this way (almost as it described @simon_ritchie😞

-create module, where you have hierarchy sorted as you need (should have saved view)

-create alternative hierarchy using import from sorted view

-we use main hiararchy in all background modules and in modules with no formula. Alternative hierarchy is applied in reporting modules, where sorting is necessary. Formulas lookup data within 2 hierarchies using list property, where we have FINDITEM by code.

-anaplan connect is scheduled to trigger process which delete all elements from alternative hierarchy and repeat step 2

Hope it can help you.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…