How to Reorder a List

Retail Anaplanners!

New functionality came out today 9/26/2020 that makes ordering lists much easier.

Release Notes: https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429

Documentation: https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html

 

A game changer for many use cases. I will show you an example plus a way to reorder a list subset. I'm sure many of you will have a more creative way to order the list subset so please share!

First you have to create a module that uses the list, and only the list, that  you want to reorder. Add a line item that contains the order you wat - can be text or general number. 

ReorderList01.png

Create a Order List Action that uses that line item for that list. You cannot select a list subset. It must be a module that uses the complete list.

 

ReorderList02.png

Run the action. Success!

ReorderList03.png

For List Subsets I created a module that uses the list subset and added a Boolean line item set to TRUE.

In the module that uses the complete list I lookup the Boolean from the module using the subset list, as shown.

 

ReorderList04.png

Blueprint:

 

ReorderList05.png

 

Create the Action using the Final Order to Use Line Item

 

ReorderList06.png

The module using the list subset is now reordered.

 

ReorderList07.png

Comments

Great, that was really needed.

Thanks for sharing easy explanation with screenshots! 

About the Author
  • Master Anaplanner/Community Boss

    Jared’s passion for retail trace back to his high school days when he sold cinnamon toothpicks to his classmates and when he learned firsthand the concept of inventory management, cost of goods sold and how to make a tidy profit. After being introduced to retail planning solutions as a buyer at Target Stores, he’s been on a personal journey ever since to help retail practitioners reach their potential by using software solutions that effectively enable their processes. Recently named a 2020 Master Anaplanner and Community Boss, Jared provides retailers, wholesalers, and ecommerce planners the rigor, training, and positive thinking needed to help them fully optimize their Anaplan platform. Prior to joining Columbus Consulting, a consultancy focused on the retail industry, Jared was a retail IT executive for Target, Tuesday Morning, Payless, and Ascena.

Latest Articles
12-30-2020
How to Reorder a List
Retail Knowledge Base
09-28-2020