Occasional Contributor

How to mass-delete data from a List

Hi experts,

 

Could someone give me a way to mass-delete data from a list?

There are 300,000 of product data in the L_Product, and when I try to select all and delete them, "Cannot delete over 10,000 records" error appeared.

 

Regards,

inoue

3 REPLIES 3
Certified Master Anaplanner

Re: How to mass-delete data from a List

Simple!

 

Create a new module dimensioned only with the list you want to delete and create a boolean formatted line item called Delete. Set this formula to TRUE

Then go to actions and create a new delete action. Pick the list you want to delete and the line item as the line item created above

image.png

 

Run the action and this will truncate the whole list

 

 

Highlighted
Contributor

Re: How to mass-delete data from a List

Hi

 

You can use the action Delete from List Using Selection to do this.

You can put conditions to selectively delete the items or you can mark the line item in a module with dimension of that list as TRUE to delete all the items

 

Below is the link

 

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

 

Thanks

Akhil

Super Contributor

Re: How to mass-delete data from a List

@Tsuyoshi_Inoue1Please use Delete from List Using Selection option.

 

Go to Actions ->New Action->Delete from List Using Selection-> Provide the necessary info to Anaplan

 

1. Action Name

2. Select the List from you want to delete the list items.

3. Select using - Select the module where you have used that particular list as a dimension.

Thanks,

Miz