How to join when destination table doesnt have unique records
My FACTS table has a field COPAKey. It is not unique.
I have another table called Billing where COPAKey is unique. The billing table has a field QTY that has the quantity for each of these records.
Anything I attempt results in the QTY getting overstated (multiplied by the # of records in the FACTS table)
I want to 'move' these records and the correct QTY to the FACTS table and then drop the Billing table because later i will be grouping the data to reduce the size of the dataset
Not sure but what if you only move QTY field to the Fact table using applymap, for that you would need to create a map table using COPAKey and QTY. But then QTY will also repeat for each row of COPAKey in the FACT table.
