I have two data tables.
The first is called “old” and the second is “new”.
I have to merge the tables by removing duplicates if any, and in the left lines add the status “ok”. the previous lines must remain and the new entries deleted.
If there were invoices in the “old” table and they are not in the “new” table, the status in the merged table should be “old”
If there are invoices in the “new” table that are not in the “old” table, the status in the merged table should be “new”
I am enclosing an “old” and “new” table and a table how it should look like after merging.
Unfortunately, I can’t attach anything because the message "
“Sorry, new users can not upload attachments.”