7 Replies Latest reply: Oct 12, 2016 12:09 PM by Sunny Talwar RSS

    Linking 2 Dimension Tables with Link Table

    Ben VanderLaan

      Hi,

       

      In the past I've been able to add/join keys to an existing table by using a third table that has both keys in it, but what should the script look like if I just want an Item table, Customer table, and Link table? I've been working off examples found online, but I can't seem to get it to work even though this seems pretty basic...

       

      For example:

      Item:

      LOAD

      ItemCode,

      CustCode,

      ItemDesc

      From

      [C:\Users\.....\Item.qvd]

      (qvd);

       

       

      Customer:

      LOAD

      CustCode,

      CustName

      From

      [C:\Users\.....\Customer.qvd]

      (qvd);

       

      Link:

      ?

       

       

       

      Any help is appreciated, thanks in advance!

      -Ben