Level 1 Model Building - Importing Data

In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists,

1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) still have to be defined in the import file.

2) the mapping for the parent (Product Family) still have to be defined during import.

I would have thought that since the parent-child (Product Family and Product) hierarchy was already defined, then parent (Product Family - Chocolate, Sours, Taffy, Fudge) would automatically be filled up but it does not seem to be so.

Is the above understanding correct?

Accepted answers

prabhu

Hi @Star,

You are doing really well.

1 thing you should change.

in the Sys06 Product Details Module, you should write a formula for Code and Product Family as CODE(ITEM('P2 Products')) and PARENT(ITEM('P2 Products')) respectively.

while setting the action you should do these

All comments

prabhu

Hi @Star,

You are doing really well.

1 thing you should change.

in the Sys06 Product Details Module, you should write a formula for Code and Product Family as CODE(ITEM('P2 Products')) and PARENT(ITEM('P2 Products')) respectively.

while setting the action you should do these

abhisheksai13

hello

can you elaborate on why you chose to map like this

CommunityMember128166

I agree with your answer. One question I have is:

When using the formula mentioned, for Product Family, I am getting Chocolate and so on, but ideally I think we should get the code of this Chocolate. Is that correct understanding

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
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…