I have a table where some old data is missing and I can't load it directly from the source. So i exported an excel sheet with the needed data. When I try to join the data into the existing table I get weird results...
Table to import has the following columns:
Order No., Start Date, End Date, process time 1, process time 2
The columns exist(and others) in the table in my QV app and I want to fill the empty fields. The history data can contain orders which I don't have in my actual table. Rows not matching the Order No should be dropped. So that no rows are added to my table. Only the missing values should be filled.
What I would do, is to create a key field, concatenating the Order No and the Sub order no as 1 field (Order&SubOrder as KeyOrder), and then do the Where Not Exists (KeyOrder)
