Creating New Records from 2 related table into a 3rd without Duplicates
I have Table1, Table2, and Table3. Following the steps below I was able to create new records from Table1 into Table2.
Use the same method.
In cases where a particular SKU and Week already exist in the record, no change occurrs in table 2. Only if at least one matching record does not already exist, will a new record be added to the table.