Load Data between two model from Numbered list to another Numbered list

Occasional Contributor

Load Data between two model from Numbered list to another Numbered list

Hi,

How can i automatically map my data load from data hub to FPA model?

 

In my data hub, i am using a numbered list(Coded) and trying to load this module in my FPA model using the same numbered list (Coded) but the mapping are not automatically updating.

 

> I have mapped the building Code-Dum to the coded building column.

tompatrickting_0-1596466891112.png

 

> The Building Code-Dum tab is not mapping automatically.

tompatrickting_1-1596466917030.png

 

> In my Building Code Dum, i have already set the code of the numbered list.

tompatrickting_2-1596467236521.png

 

 

Thanks in advance for the help.

Tom

 

14 REPLIES 14
Highlighted
Super Contributor

Re: Load Data between two model from Numbered list to another Numbered list

hi @tompatrickting 

Actually numbered list in Anaplan, even if codes are same in the source and target model, it doesnt mean that they point to the same item as numbered list item generated (#1 etc.) is unique for each Anaplan model, and different id is generated at the back for each model, so you need to actually map based on the name item # which will then look for the same # in the target model ,

So try to use column 2 to map to dum code list num

Highlighted
Master Anaplanner/Community Boss

Re: Load Data between two model from Numbered list to another Numbered list

@tompatrickting 

 

Map on the code, not the # of Id nor the Name when using a numbered list.  The code is the only thing that will work across models.  The reason your import is not working is due to the 2nd picture, you should have codes in there instead of #1, #2, #3, etc.  So, check your view for the correct information.

 

Rob

Highlighted
Master Anaplanner/Community Boss

Re: Load Data between two model from Numbered list to another Numbered list

Hi @tompatrickting,

 

We should use CODE only to import between 2 models, not NAME.

You are mapping it correctly. I think initially you mapped it to the Column 2:Building Code Name, then later you mapped it to Column 4: Building Code, but the system is still referring Column 2:Building Code instead of column 4. 

 

You can fix this in 2way,

1. Simply delete the action and recreate it, 

or

2. Map Column Headers to the Building code-Dum and check the Building code-Dum tab, all the previous mapping are gone now. 

    Go to the Mapping tab and this time map it to the Column 4: Building code. Now check the Building code-Dum tab, this should work. 

 

Regards,

Vignesh M

Highlighted
Occasional Contributor

Re: Load Data between two model from Numbered list to another Numbered list

Thanks all for responding.

 

Hi @VIGNESH.M, i already tried both option 1 and 2 but still no luck. I also tried to delete the numbered list and re-create but still not mapping automatically if i use code.

 

I cannot use directly the list name since i am synching 2 model and users can create or delete manually in the model that will cause miss alignment of the # list name.

 

Is the only option i have here is to create a normal list?

 

Thanks again for the help.

Tom

 

Highlighted
Master Anaplanner/Community Boss

Re: Load Data between two model from Numbered list to another Numbered list

@tompatrickting 

In the target module, do you have a line item with the code of Building -Dum?  You will need this to map to which is why your 2nd picture isn’t mapping.

 

Rob

 

 

Highlighted
Occasional Contributor

Re: Load Data between two model from Numbered list to another Numbered list

@rob_marshall 

 

Do i need to create a line item in my target module for the building code? I am already using the building code as applies to.

tompatrickting_2-1596505181735.png

 

Here is what i have in my mapping. It its showing the numbered list name not the code:

tompatrickting_0-1596504945888.png

 

 

Here is my numbered list Building Code-Dum

tompatrickting_1-1596504997578.png

 

Highlighted
Master Anaplanner/Community Boss

Re: Load Data between two model from Numbered list to another Numbered list

@tompatrickting 

yes, you will need that in the target to map to.

 

Rob

Highlighted
Occasional Contributor

Re: Load Data between two model from Numbered list to another Numbered list

@rob_marshall 

 

I tried to add a line item in the target module for building code but still doesn't map automatically in my building code mapping.

 

Mapping in the line item:

tompatrickting_1-1596508274569.png

 

Mapping in the building code:

tompatrickting_0-1596508246984.png

 

Highlighted
Master Anaplanner/Community Boss

Re: Load Data between two model from Numbered list to another Numbered list

@tompatrickting 

 

You need to use the code as the source as well.  In your picture, it looks like you are using the name or the member because it is the #number.

 

Rob