Delete multiple items/rows from list.(more than 5000)

Hello Members,

I wanted to delete more than 5000 rows(nearly all) from an independent numbered list but at the same time wants to save the list and its properties.

If we delete any items/row from the list containing more than 5000 rows, it says to select and delete and by this only one is getting selected and not more than 1.

One way is to export the properties and delete whole list and then create another list ,add properties....

But I'm looking for another bulk deletion of items from the list, where i can delete all the items and not individual.

Kindly help me out.

Accepted answers

LipChean_Soh

Hi,

Do have a look at the link below:

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Delete_from_List_Using_Selection.html?_ga=2.244226501.1534137348.1556540715-1239638901.1550667215

Put in the formula Delete = True to select all entries.

Screen Shot 2019-05-07 at 2.11.42 PM.png

Thanks,

LipChean

akhil.kohli

Hi Sushmit,

My bad, was not able to explain comprehensively.

PFB the steps

1. Lets assume a list Lis1 as below. This has 1000 Items

2. Now Create a line item with applies to as this list, format as boolean and mark it true. If you want to delete specific then only mark those

3. Now in Actions, create an action of type 'Delete from List using selection' and point to this line item

Run this action, and it will delete the items

Thanks

All comments

LipChean_Soh

Hi,

Do have a look at the link below:

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Delete_from_List_Using_Selection.html?_ga=2.244226501.1534137348.1556540715-1239638901.1550667215

Put in the formula Delete = True to select all entries.

Screen Shot 2019-05-07 at 2.11.42 PM.png

Thanks,

LipChean

akhil.kohli

Hi Sushmit,

Delete from List using selection is the way you can achieve this. Please check this action in the Settings>Actions. You will have to create a boolean line item with applies to on this dimension and then point this to the particular action as defined

Hope this helps

Thanks

Akhil

sushmit.singh

Hello Akhil,
Thanks for the prompt reply.
Delete from list using selection would required selection of items more than 5000 times.
That would be same as selecting/deleting from list.

sushmit.singh

Hello LipChean,
Thank you for the prompt reply.
I have tried that method but that would required another clicking 5000times to the rows to delete.
Any other method to delete under 10click (10 is also more but would be less than 5000)

Regards
Sushmit Singh

LipChean_Soh

Hi,

It was mentioned in my previous post, but i'll repeat.

Put in the formula 'Delete = True' in the module to select all entries automatically.

Thanks,

LipChean

akhil.kohli

Hi Sushmit,

My bad, was not able to explain comprehensively.

PFB the steps

1. Lets assume a list Lis1 as below. This has 1000 Items

2. Now Create a line item with applies to as this list, format as boolean and mark it true. If you want to delete specific then only mark those

3. Now in Actions, create an action of type 'Delete from List using selection' and point to this line item

Run this action, and it will delete the items

Thanks

sushmit.singh

Thank you Akhil.

This worked but in module!
it took me a lil time to understand!!
Anyways, Thanks a lot.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385