Step 3 - Create Product Table from Excel file¶

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.

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.

Downloads¶

• AW_Product_Master.xlsx