Change the data type of the ProductKey column to Whole Number
Load all the Sales files. Note: There are multiple sales files found in the SalesAllYears. There is a single file for all the sales data for an entire year. We need need to load all of these files into a single table. Try to use the load from folder option as opposed to loading each file individually
Remove the Letters USD from the Sales Column
Change the Sales column to a data type of Whole Number
Rename the created table to be called just Sales
Delete the column named Source.Name
Load all the data
Check that all the data has loaded correctly by clicking on the Data view
