Import file with several sheets

Hi,

I have a module where I have a number of line items and two lists as dimension. One as rows and one as page selector. I want to build a function to export all data from that module, edit it in excel and then import the same file again, and hence get the values updated in Anaplan.

Now to the issue: When the file is exported, all the different pages are being exported into different sheets in Excel and I can't figure out how to map the import correct to get the values to update properly since the only place the list item form the dimension is mentioned in the excel file is in cell A1.

Does anyone know how to tackle this? Any help is appreciated!

Thanks!

Accepted answers

All comments

kavinkumar

HI @fredrickstraube,

Can you please do pivot the dimension from Page to Columns cos Anaplan will do the export into different sheets based on number of items in that list (All pages are checked in export action). Is there any particular reason to use it in the page selector? If not please bring the dimension to the column and do the export.

I hope this helps!

Regards,

Kavin.

rob_marshall

@fredrickstraube ,

May I ask a clarifying question...Why? Why are you wanting, I presume, users to export data from Anaplan, update the data in Excel, and then reimport it? Why not have them just update the data within Anaplan which will save on concurrency or blocking actions?

Thanks,

Rob

Misbah

@fredrickstraube

Please Export it in Tabular Single column Layout instead of Grid Layout. Attached screenshot for your reference.

Let me know if that helps.

Thanks,

Misbah

@kavinkumar

There is a catch here. If you shuffle your dimensions from Page selectors to Columns - It will throw an error if your list is too big - Anaplan has put a limit on the number of columns that it extracts.

Workaround can be - you try it in Tabular format - Single or Multiple. Here in this case it can be Single.

Thanks,

Misbah

mikejorg

You could use filtering to remove unnecessary list items to avoid this error. However, @rob_marshall raises an an excellent point. Why would you want to export, change the data, then import? It would make more sense to configure the module and/or model to be friendly to user input.

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…