Step 3 - Create Product Table from Excel file

Created by: Kristinn Magnusson

In this step, you are going to continue with exMonDM and build out your first project. Specifically, you will be importing a table containing all the Adventure Works products. Creating a Table from an Excel file is easily done with the Create Table Wizard.

If you have not yet completed step 2 of this training, please click here.

Resource: Download the project file to your Computer: AW_Product_Master.xlsx

Import Table from Excel or Flat File

  1. Click on Create Table from the Start Page
  2. Import Table from Excel or FlatFile



  3. Click Browse.. and navigate to the downloaded file.

  4. Modify the Table Name to Product and Click on Next

     

     

  5. Change the configuration mapping
  6. Change the Project to Product Master
  7. Change Datatype of Safety Stock Level to Number and Sell Start Date to DateTime.
  8. Click Verify to go to the Next Step



  9. If all looks good click on Confirm to start importing.




  10. Import should now be final, click on Close and imported data should be visible in the table.




Next steps

To continue with this training, click here.