2 Replies Latest reply: Apr 20, 2011 5:10 AM by Muncho Ts RSS

    Natural Join Problem - not joining rows

    Aaron Couron

      I am creating a Link Table from multiple fact tables. I am basically using JOIN to get the combined keys in the same rows with their common parts. But it seems that some of these parts are creating new rows even when the like columns have the same information.

       

      So I am ending up with a link table like this:

      KeyStoreDateProd KeyDateProduct Store Date Product

      1 456 1/2/2000 123

      1 1/2/2000 123

       

      Instead of this:

      KeyStoreDateProd KeyDateProduct Store Date Product

      1 1 456 1/2/2000 123

       

      The kicker is that the behavior is not consistent. Some rows are merging properly and others are being added. Is there any behavior or loading protocols I should be looking for? I am using: JOIN (LinkTable) LOAD