Awesome crystal clear tutorial. Prove me if I am wrong, it is the best SQL case study tutorial on youtube, by all standards. Being a person who enjoy programmatic data cleaning, I really love the dynamic and interactive approach in whole analysis. Now, is there anything that could be missing in a typically SQL data analytics Sales project? Not sure, it could be the market share analysis of the top 10 brands or the states
import failed. receiving "row import failed with error: "incorrect integer value: " for column 'condition at row 1", 1366. This is the date column. I can see workbench is typing this as an integer field. However; I can import into Excel and the date column is formatted correctly. I resave as a csv from my Excel but it still fails in workbench. even when the column is unchecked for loading it still fails.
ok not correct. I was interpreting the wrong column in the error message. The 'condition' column was the issue. I looked at the csv file in power query and this column has null values. I replaced the null values with a zero (so the data type would stay as int). the csv file is importing now with no errors. However; as noted with another comment, the data import is taking a long time.. workbench is active right now...
Glad you got the import resolved. If the data import is taking a long time in MySQL Workbench, you could look into the "load data infile" command, which is a command to import a CSV file. In my experience, it's faster than the Table Data Import Wizard.
Is this in MySQL Workbench? If so, you may need to keep the window active, as it seems to slow down if it's in the background. If not, then I'm not sure why