List Sorting ....

logikalyan · 2025-01-28T08:43:52+00:00

There was an error rendering this rich post.

Hi there,

I wondered if anyone can help.

I have a big list (more than 3000 items) which I want to sort alphabetically. I tried using Anaplan Order List functionality but it looks like even with that, we have to sort the list manually first. Instead, I can order the list manually right?

Am I not using Order List functionality properly (this is first time). Or is there a easiest way to achieve this?

I appreciate any advice from Anaplan guru's.

Thanks

Kal

Accepted answers

All comments

SriNitya

@logikalyan
While creating Order list action mapping of line item (with the format Text, Number, Date or Time Period) needs to be provided which acts as a driver to reorder the list

logikalyan

Hi SriNitya,

For Order List I create a model with list (that needs sorting) and a line item with right format. But I still have map the list items to the line item (correct me if I am wrong). i.e. mapping them with sort order manually isnt it? For 3000 items it will take a long time.

So I wondered if there is a easy way.

Thanks

Kal

SriNitya

@logikalyan Manual intervention is not needed.
In a module dimensioned by the list you want to reorder create a text formatted line item and use formula as name(item(list..)) and then use that line item while creating the Order List action.
This will solve your issue.
Hope it helps

logikalyan

Hi SriNitya,

Thanks for your response.

I will try this and let you know how it goes.

Kal

Arnab116

Hi @logikalyan ,

To address your issue, the Order List functionality is the most effective and reliable solution. For the Order List, ensure that the line item selected for the action is in text format. To achieve this, create a text-formatted line item that converts the list name to text using the NAME function in a system module. If your list is formatted as a number, you can directly use the display name in the formula for the text-formatted line item within the system module.

Once the action is configured, place it in the process immediately after the import action for the list. This way, the order will be automatically managed each time the list is populated.

Let me know if you have any further queries.

Hope this helps.

Thanks

Dikshant

Let's say you want to sort the country list.

Create a System module, SYSxx Country Details, and a line item Name. Make it text format and formula as:

If the list is flat,

NAME(ITEM(Country))

If list is numbered list

Country.Display Name

Then create an order list action and use this line item to sort the items alphabetically without manual intervention.

logikalyan

Hello everyone.

Mine is a numbered list and I added a display name, But when I try to add list.display name in the line item formula, I get below error. I am sure this might be something silly I am doing.

Any ideas!

Kal

Dikshant

I hope the display name property is in text format.

Just use Test KL.Display Name.

logikalyan

Hi Dikshant,

Yes the display name property is in text format and I used the same as per my screenshot.

But get the same error.

Thanks

Kal

Dikshant

Use this formula:

Test KL.Display Name

Remove NAME and ITEM functions

logikalyan

Hi Dikshant,

Its still not working. Here is how I am testing with full details. My List has three items A, B, C sorted incorrectly. My objective is to sort them properly.

This is a number list with display name formatted as text below:

I added display names manually for this test. I have created a Sys module with above list and a text formatted line item, Line item formula is TESTKL.display name as you suggested.

Later I created a Order List import. I am expecting to see the right order. But they are unchanged.

What am I doing wrong?

Thanks

Kalyan

logikalyan

Sorry for the confusion its working now. Thanks for all your support everyone.

Kal

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…