What does this mean? Unable to copy files into table. Number of columns in file (3) does not match that of the corresponding table (8), use file format option error_on_column_count_mismatch=false to ignore this error File '@TUITIONASSIST2/ui1664916259322/9.15.20-Tuition Assistance Majors -Employment at St. Jude.xlsx', line 2, character 1 Row 1 starts at line 1, column "TUITIONASSIST2"["APPLICATION_STATUS":3] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.
What does this mean?
Unable to copy files into table.
Number of columns in file (3) does not match that of the corresponding table (8), use file format option error_on_column_count_mismatch=false to ignore this error File '@TUITIONASSIST2/ui1664916259322/9.15.20-Tuition Assistance Majors -Employment at St. Jude.xlsx', line 2, character 1 Row 1 starts at line 1, column "TUITIONASSIST2"["APPLICATION_STATUS":3] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.
Answer:
It looks like you have a header row in your file.
Have you tried using the optional parameter SKIP_HEADER to skip that first header row?
SKIP_HEADER = 1
Step by step
Solved in 2 steps
