Forum Discussion
Detected Type Mismatches
Hello - this table will automatically be created when you attempt to load data to the model and there are errors somewhere in the records. The problem may or may not be a data type issue. The table created automatically includes the type mismatch step. The best way to see the errors would be to view the errors table that was created. Scroll through the columns and you should see a column which contains a value that looks like a hyperlink with the word Error. If you click the hyperlink in the cell it will drill down to the error and tell you what the exact problem is. You can also see the actual problem without drilling down by clicking on the white space next to the hyperlink (in the same cell) and a preview will appear which displays the actual error message. I find that type errors are frequently numbers/dates that are attempting to be parsed as text or vise versa.
Hello - this table will automatically be created when you attempt to load data to the model and there are errors somewhere in the records. The problem may or may not be a data type issue. The table created automatically includes the type mismatch step. The best way to see the errors would be to view the errors table that was created. Scroll through the columns and you should see a column which contains a value that looks like a hyperlink with the word Error. If you click the hyperlink in the cell it will drill down to the error and tell you what the exact problem is. You can also see the actual problem without drilling down by clicking on the white space next to the hyperlink (in the same cell) and a preview will appear which displays the actual error message. I find that type errors are frequently numbers/dates that are attempting to be parsed as text or vise versa.
Great! Thank you for your kind explanation! I have 3 million cases, so I'm not sure if I can locate the error cells, but will try and let you know.!
You shouldn't need to check each one individually. Getting the error message for one cell and fixing it will usually resolve all the errors in the column.