Clearing anaplan data before new load

Hi all,

I have a module with data value against every month, and my process takes care of loading the new file data to the module.

before loading new data file, I want to have a action to cleanup the existing data and the load the file data.

Dont want to delete the target list here, but only the data in the module.

Regards,

Madhu

Accepted answers

All comments

VIGNESH.M

Hi,

It's a 2 step process.
Step 1: Create a line item "Zero out" in your Target module and load this value into your target line item.
This will clear out the existing values.
Zero Out --> Demand, in the same module

Summary of the new line item is none and formula is 0.

Step 2: Load the new value from your file.

~Vignesh M

LipChean_Soh

Hi,

Alternatively, you can use a standard feature within the import action shown below.

Since the 'clearing' options appear on each tab, choose 'All items' for the list of which you intend to clear ALL items.

Screen Shot 2019-07-24 at 9.13.44 AM.png

Thanks,

LipChean

ArunManickam

I agree with @LipChean_Soh , You should use the standard clear option, you could simply clear 'All items' in the Line items tab. That is like beginning with a clean slate every time you run the action.

VIGNESH.M

Yes, I totally agree with you Arun.
We should use anaplan standardized process.

If we want separate action in a dashboard to clear and input the data in dashboard, then we need a separate "Zero Out" action.

If it's upload only , then we should use Anaplan standard action to clear all items and load it.

Regards,
Vignesh M

kavinkumar

HI Guys,

What if I want to clear only one line item and don't want to disturb the other line items(Manual inputs). So it is best practice to use 'All mapped items" so that you will not loose any other data.

@MadhabikaM If you want to create an action, go with the approach of creating line item and make it as No data as this will save your model size(This will clear out for any formatted line item ex. Number, Text, Boolean, list etc.) and import into your desired line item.

I hope this helps.

Regards,

Kavin.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…