Hi,
I am trying to import data from one module to another. And in one of the mapping, I gave the option as 'Ask each time import is run'. The issue I am facing is it is not mapping to one particular record, instead, it is loading all the records into one record.mapping
Importing from this module
Importing into this module
Solved! Go to Solution.
Hi Vamshi,
In your case, "Ask each Time Import is Run" will import the sum of the records data into 1 particular record.
Example, the Sum of all records loaded into ITEM 1 which I selected.
Try the alternate way to achieve the same,
Create a filter line item to select which particular record needs to be copied.
Apply the same filter in your import view and map the dimensions.
~Vignesh
Thanks for the reply.
What you suggested will load only data for one record. What I am looking for data should be loaded for each recorded separately on the prompt.
And records will keep on adding. So in future data should be intact for the old records that are loaded. Import should only change the data for the new record.
Hi Vamshi,
What I suggested will load data for one record based on the Item in the filter.
Next time, select the different record and load data for that record only.
Your previous record data will be still the same.
~Vignesh
Yes, Vamshi.
But That is not what I am looking for. Import action will on the dashboard and the user just wants to select the one record at a time and import data.
It depends on what you are attempting or wanting to do with this import. A couple of things to note:
From what I can see in your mapping, you might have the the mapping incorrect. If your record list is long (longer than 5 members), I am not sure you will want to be prompted everytime this action is run. Instead, change the mapping, as well as your view,
Hope this helps,
Rob
Can I ask why are you importing from module to module driven by users?
This is not "normal" Anaplan modelling so I'm interested/concerned as to why you need to do this.
We should be trying to minimise user driven actions wherever possible especially for data movements
David
Hi @DavidSmith ,
Its a requirement from the user. Like I have data set in a module for several locations ad dimension.
Ex for Jan Loc A 30
Loc B 40
Loc C 50
this data keeps on changing
so in jan he want to take the snapshot of it
for record 1 Loc A jan 30
record 2 Loc B Jan 40
So if in Feb data changes to
Loc A 35
Loc B 45
Loc C 55
and he creates wants to create a new record
say record 3 Loc a Feb 35
other previous records data should not get altered.