Level 1 Model Building - Importing Data

Highlighted
Regular Contributor

Level 1 Model Building - Importing Data

Hi

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?

 

Star_0-1584406929753.png

 

 

 

3 REPLIES 3
Highlighted
Super Contributor

Re: Level 1 Model Building - Importing Data

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

 

 

Capture.JPGCapture1.JPG

Sorna Raja Prabhu
Highlighted
New Contributor

Re: Level 1 Model Building - Importing Data

hello 

can you elaborate on why you chose to map like this 

Highlighted
Occasional Contributor

Re: Level 1 Model Building - Importing Data

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