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.
Please help
Unfortunately, I can’t attach anything because the message "
“Sorry, new users can not upload attachments.”