Level 1 Model Building: Import data to SYS06 Product Details module

In Module 7 of Level 1 Model building, we are asked to import product data into the Product Details module and map to the source. However, my mapping does not seem to be accurate, and I cannot figure out the issue. I've attached screenshots of what my mapping looks like, as well as what it results in. Any and all help would be much appreciated!

results resultsoriginal mappingManually mapping some itemserror message

Accepted answers

JaredDolich

@Belson97

Take a look at grid view on the list. Make sure your Product Family codes are loaded. You may need to reload it.

If that looks good lets take a look at the details of the errors as @rob_marshall suggests.

All comments

JaredDolich

@Belson97

Oh, so so close.

Make sure you Product Family Line item is formatted as a list "P1 Product Family". Looks like its formatted as a number. Try it again.

You got this!

Belson97

@JaredDolich Thanks for the quick reply! I changed the format to List P1 Product Family, but now I am getting an error that says the items are not located in the list. I've attached screenshots of the error and my P1 list. p1 list.png try again.png

rob_marshall

@Belson97

To get a better idea of what is going on, after you run the action and get the error screen, click on the Details tab and it will give you more granular information on the errors.

Rob

JaredDolich

@Belson97

Take a look at grid view on the list. Make sure your Product Family codes are loaded. You may need to reload it.

If that looks good lets take a look at the details of the errors as @rob_marshall suggests.

Belson97

@JaredDolich Product List was the issue. This is how my content returns now which I believe is correct yes? Thanks for all your help Jared! Screenshot 2021-02-26 094609.png

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…