Hello,
Is there a way to reset the number generated in a numbered list?
Also, is there a way that we can sort a list in alphabetical order after import?
Thank you!
Hi Sarah,
Yes, with the new release on 13th April, the Workspace Admins have a provision to reset the numbered list index if it is between 899,999,999 and 999,999,99. PFB the screenshot showing the same options
The options to reset gets enabled when the count in the list reaches 899,999,999
Thanks
Akhil
Can I ask why do you need to reset the list?
You shouldn't be referencing the code directly in a formula
In terms of sorting on a list, this has been requested a number of times
https://community.anaplan.com/t5/Idea-Exchange/Sorting-items-by-code-or-name-in-number-lists/idi-p/34843
But it is worth voting for it again!
David
To physically sort list members, you need to destroy the list (delete all members) and reload the members sorted. If this list is not used in too many line items that contain stored data, you can create a process that include the following (assume that the list that you want to sort is called LIST_A):
1. Copy all members of LIST_A to another temporary list (call it tmpLIST_A). Create a module dimensioned by tmpLIST_A (call it tmpMODULE_A). The line items in the module should include at least the name, code, parent name, and parent code of the list members. All other property values should also be included in this module.
2. Copy parent-child information (name, code, parent name, parent code) of the list along with other properties to tmpMODULE_A. In tmpMODULE_A, create a view that shows all line items sorted by the member list name (call this view vwSortedView).
3. Copy the contents of all line items (dimensioned by tmpLIST_A) to temporary modules.
4. Delete all members of LIST_A.
5. Import vwSortedView back to LIST_A
6. Import back the line items that contain data. This are the line items that are backed up in Step-3.
7. Finally, delete all members in tmpLIST_A so that it is ready for the next sort.
All of the above actions can be place in a single process so that the admin can just run the process to sort the list.
I hope it helps.
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
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,
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…
