Level 2 Model Builder Training- DAT01 Sprint 1

jenniferhallce8995
jenniferhallce8995
in Modeling

I'm having difficulties loading the beginning inventory positions data into DAT01. 

 

My SKU fields map correctly, however the data is just not pulling through as I would expect. What am I doing wrong here? 

Screenshot 2020-11-27 at 13.06.36.png

 

Screenshot 2020-11-27 at 13.07.02.png

 

Tagged:

Best Answer

  • Anilkumarch
    Anilkumarch
    Answer ✓

    @jenniferhallce8995 Just delete the line items(created with inventory numbers) that are created and load with selecting fixed line item for beginning inventory column. In you mapping screenshot you mapped beginning inventory instead you mention as "fixed line item", after that in you right hand side selection keep the same for "Data values from" field.

     

    This make you module and action looks good.

Answers

  • Akhtar.shahbaz
    Akhtar.shahbaz

    Hi @jenniferhallce8995 ,

     

    I am not sure how are you getting value in the column which looks like a line item in 2nd screenshot.

     

    Can you try below mapping?

    Screenshot_543.png

     

     

    Hope this helps!

    Thanks

    Akhtar

  • jenniferhallce8995
    jenniferhallce8995

    Thank you for your reply, although my import is still not looking as I would expect. The beginning inventory values are showing as column headers as opposed to mapping against the correct distribution centre.  

    Screenshot 2020-11-30 at 08.52.36.png

Categories