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

sushmit.singh

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.

.

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.

 

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

AK

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

sushmit.singh

Thank you Akhil.

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