New Contributor

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.

.

7 REPLIES 7
Super Contributor

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

Hi,

 

Do have a look at the link below:

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Delete_from_...

 

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

 

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

Thanks,

LipChean

New Contributor

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

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
Super Contributor

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

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

Contributor

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

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

New Contributor

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

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.
Highlighted
Contributor

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

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

New Contributor

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

Thank you Akhil.

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