List Sorting ....

logikalyan

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

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