Clear Large Amount of Data

TLam99
Occasional Contributor

Clear Large Amount of Data

Good Afternoon,

 

I hope someone can help, so far it has taken me over 2 hours to clear out a large amount of data in a module (more than 500000 cells). Is there any quick way of doing it? I still got 7 more to clear data from.

 

For some reason when importing data in Anaplan, it did not clear out all data before the import, which had caused figures mismatch.

 

Any help or advice is welcome.

 

Thanks in advance.

 

Thanks

Tony

6 REPLIES 6
ChrisStauffer
Certified Master Anaplanner

For 'quick and easy' manual data removal you can type an '=0' into numeric line items to zero out data, then remove the '=0' formula.

 

Also please see this article for more in depth solutions.

 

https://community.anaplan.com/t5/Anaplan-Platform/How-to-clear-data-from-a-module/m-p/442#M1922

 

 

rob_marshall
Moderator

@TLam99 

 

Tony,

 

As Chris alluded to, in your import definition, change the radio button on the upper righthand side to to All instead of matched.

 

2022-05-25_11-42-31.png

 

2022-05-25_11-42-44.png

 

2022-05-25_11-42-57.png

 

 

Rob

sobaid
Regular Contributor

As @ChrisStauffer said to place 0 in the forumla for numeric formatted cell, you can also blank the cell for text or list formatted Line Item by placing "blank" in the formula.

CommunityMember111277
Frequent Contributor

I suggest you do some deep analysis of this error.

 

It seems like you have performed this import function earlier, & you didn't faced any issues then. If that is the case, then try to figure out what makes it different this time. Any new recent changes made which you are not aware of.

Typically, what worked earlier should work now as well unless someone has made any changes in the tool or the data which you are importing.

 

If this is the first time its happening, then check the import mapping especially (clear data modules). Run these modules manually, check for deviation.

Alexandru.Rosca
Frequent Contributor

You could also create a "clear" action if there is a specific day in your process when you need the data to be cleared out and not after every file upload. You can achieve this by creating a similar module with "No Data" format for the line item. Then in target module create an import action that pulls from the newly created module.
gaurav_sharma-bng
Certified Master Anaplanner

i just love the feature of adding formula '=0' in number formatted item and '=BLANK' in text line items to quickly delete the complete dataset for a line item. It is amazing!!!! 

 

Don't forget to remove the 0 or BLANK formulas once the data is cleared. 🙂