How to mass-delete data from a List

[Tsuyoshi_Inoue1]

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

[anirudh]

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

Run the action and this will truncate the whole list

[Akhil.kohli]

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

[Misbah · Accepted solution]

@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