1.5.2 Activity: Import Data into Beginning Inventory_not getting correct data after import

SupriyaH
Contributor

1.5.2 Activity: Import Data into Beginning Inventory_not getting correct data after import

I have downloaded below inventory file.

SupriyaH_0-1656924305957.png

Performed below mapping.

SupriyaH_1-1656924423399.png

SupriyaH_5-1656925110780.png

 

Still I am not getting correct output( Beginning Inventory column).

SupriyaH_2-1656924682801.png

I am getting below output. Could anyone please help me.

SupriyaH_4-1656925053978.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
sobaid
Regular Contributor

Hi
You can Show/Hide the line item you want in this case you can select the line item Beginning Inventory and create a saved view then you can run export from the view. or

Instead of creating the line item (Filter in your case) you can select the line item Beginning Inventory and click on Filter Icon above and create a filter Data01 Beginning Inventory > 0

View solution in original post

6 REPLIES 6
sobaid
Regular Contributor

Hi @SupriyaH
Your import is correct, try changing the location from New York to San Fransisco, you'll see the value 9500 in Raising the bar_EN and so on. Hope Your question is resolved.

sobaid_0-1656930013625.png

sobaid_1-1656930040128.png

 

 

SupriyaH
Contributor

Thanks @sobaid
In model building activity they require below output.

SupriyaH_0-1656930702843.pngSupriyaH_1-1656930791671.png

Could you please guide me the steps how to get this output. 

sobaid
Regular Contributor

I see,
Step1: You have to pivot the P3 SKU and s G3 Location distribution centers in rows and line item in column and,
Step 2: Apply filter on line item to be greater than 0.
Step 3: Go to P3 SKU Column and select levels to show (options you get when you right click), and only select P3 SKU, similarly for distribution centers let the level is marked for distribution centers only. Your view is good for export!

SupriyaH
Contributor

@sobaid Hi

I have applied filter and got below result.

SupriyaH_0-1656933685692.png

I am not able to create view Export as they want only 3 columns in output. Could you please guide me through screenshot as I have tried from select levels. But unable to get output.

 

SupriyaH_1-1656933921151.png

Thanks is advance 🙂

 

sobaid
Regular Contributor

Hi
You can Show/Hide the line item you want in this case you can select the line item Beginning Inventory and create a saved view then you can run export from the view. or

Instead of creating the line item (Filter in your case) you can select the line item Beginning Inventory and click on Filter Icon above and create a filter Data01 Beginning Inventory > 0

SupriyaH
Contributor

@sobaid Thanks I have got required output