I have a table with 9,000 records (MYdb) and 4 visualisations linked to the table.
I am at a point where I have another 800 records (update001) to add to the original table. I expect I will have to do this three times a year.
Data is in the same format in both tables.
I have tried the following SQL
insert into MYdb select * from Update001
This creates an error
column "quantity" is of type integer but expression is of type text.
Any ideas as the best way to do this?
All the columns are Strings except two, quantity and year that are set as number.
I have checked both the tables for the column name and format and both I have the exact same details in both tables.
The year column was in a different sequence in the table.