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.

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

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

Thanks in advance for the help.

Tom

Accepted answers

All comments

Kanishq17

hi @tompatrick.ting

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

rob_marshall

@tompatrick.ting

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

VIGNESH.M

Hi @tompatrick.ting,

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,

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

tompatrick.ting

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

rob_marshall

@tompatrick.ting

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

tompatrick.ting

@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.

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

Here is my numbered list Building Code-Dum

rob_marshall

@tompatrick.ting

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

Rob

tompatrick.ting

@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:

Mapping in the building code:

rob_marshall

@tompatrick.ting

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

tompatrick.ting

@rob_marshall

I already mapped the building code in that screenshot.

We are now thinking of creating a staging module in our FPA removing building code in the applies to and replace by #Numbered list then put the building code in the line item.

I created a concatenate of GL Code and Building code to create the #Numbered list staging to store the data and will just link from the staging to the reporting module.

Thanks for the support.

Tom

prabhu

Hi @tompatrick.ting,

I am sorry. I know that i am late to this discussion but i replicated your scenario and it works well for me

which means Numbered list codes in my data hub are automatically mapped to Numbered list Codes in my spoke model.

I am not sure why are you facing this.

But one question to you

1. Have you first loaded the numbered list to your FPA model...?

I think you might have forgotten to load numbered list.

Before loading to the values or data to the module first you have to load the list.

Thanks,

rob_marshall

@tompatrick.ting

DM me when you get up and running and we can figure this out.

Rob

tompatrick.ting

Guys, thanks for helping. We decided to convert the list to a normal list instead of using a numbered list. We limited the character to 60 to avoid errors.

rob_marshall

@tompatrick.ting

Booo!!!!!! Offer still stands if you need it or want it.

Rob

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…