Can Anaplan Connect with batch scripts append data?

Hello, I'm using Anaplan Connect with batch scripts to integrate data into my Anaplan models. I'm interested in understanding whether Anaplan Connect supports the ability to append data to existing records in the models. Could you please provide information or guidance on achieving data appending using batch scripts in Anaplan Connect? I'm looking to ensure that the historical data in the model is preserved while updating and exporting specific data points. Any insights or references to relevant documentation would be greatly appreciated. Thank you

Accepted answers

All comments

pyrypeura

Hi,

Anaplan Connect behaves in same way as you would be loading in the file manually to Anaplan. So as by default functionality Anaplan overwrites possible previous values if those exists in Anaplan before hand. If you don't want to change these data points you would need to exclude those from your import or you should build a logic in Anaplan that stores the correct values for you from the import.

kartiendasolventoph

Thank you @pyrypeura . Question again, how do you do incremental data loading in Anaplan using batch scripts?

hendersonmj

In Anaplan, Import actions can only replace existing values, not accumulate.

Let's say your line item is named "Value".
As a workaround, you could add three line items "Incremental Load Value", "New Total Value", and "Zero". Give them these formulas:
New Total Value = Value + Incremental Load Value.
Zero = 0
Incremental Load Value = <blank … no formula>

Revise your data import action to put new values into Incremental Load Value.

Next, create a view and import action that import New Total Value into Value and that import Zero into Incremental Load Value. The second part clears the incremental load so those doesn't hang around to double up on the next data load run.

Be aware that incremental loads can be messy … if something goes wrong mid-stream, you don't want it to continue as though everything were fine. In Anaplan Connect, I have written a more advanced script that checks for successful completion of the first data upload action before running the copy-and-clear action. This requires capturing a log file (redirecting the stdout and stderr of the line that calls AnaplanClient.bat), then reading that log to look for the expected success message. If no success message is found, don't continue on to run the later copy-and-clear action. This does require some scripting skills … all of mine come from stackoverflow.com ;-).

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!