Importing is not updating correctly

Sravan_Kumar

Hi Friends,

I am trying to import this .csv file into my module.

But I can't do so.

I think I need to create a Col ID.

My ques: will the newly created Col ID able to match data in another module with different ID?

I will brief my problem elaborately, in case you find any difficulty in understanding.

Accepted answers

Akhtar.shahbaz

Hi @Sravan_Kumar

I have tried to create import action as per your import file

Template in csv format

2. Create a module with Product as a dimension and one line item Unit sold

If you want sales type then add as dimension

3. Create import action:

Make sure set the correct mapping for time period:

Output after running the action:

Hope this helps!

Thanks

Akhtar

naushad786

Hi @Sravan_Kumar ,

I think that you are not mapping TIME Dimension correctly in the mapping Tab. you have to choose Period to M-Y then it will import successfully.

Thanks,

Naushad

All comments

Rashmih

Hi @Sravan_Kumar ,

Newly created Col ID will only be able to match data if you use the same dimension in the other module or you build some mapping mechanism such that newly created Col ID can match/lookup the dimension in another module.

Sravan_Kumar

Okay @Rashmih.

Please tell me, how will I import this file.

Rashmih

Hi @Sravan_Kumar ,

Do you have Products as a dimension?

You can create a module with Product and Time as Dimension and Units Sold as line item (Format Number) and then import the data.

Akhtar.shahbaz

Hi @Sravan_Kumar

I have tried to create import action as per your import file

Template in csv format

2. Create a module with Product as a dimension and one line item Unit sold

If you want sales type then add as dimension

3. Create import action:

Make sure set the correct mapping for time period:

Output after running the action:

Hope this helps!

Thanks

Akhtar

naushad786

Hi @Sravan_Kumar ,

I think that you are not mapping TIME Dimension correctly in the mapping Tab. you have to choose Period to M-Y then it will import successfully.

Thanks,

Naushad

Sravan_Kumar

Thanks @Rashmih & @naushad786

It worked correctly.

Thanks @Akhtar.shahbaz again for the detailed screenshots.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…