2 Replies Latest reply: Dec 29, 2017 2:12 AM by pradosh thakur RSS

    Use column from other table

    zahid Rahim

      Dear Experts,

       

      I want to make a composite key from two joined tables so that i can use this composite key to join with my 3rd table. Below is the example:

       

      cm_cmpt_dtl:

      Load PERIOD_ID,

      INVENTORY_ITEM_ID,

      CMPNT_COST

      from  [LIB://QVD/cm_cmpt_dtl.qvd] (qvd);

       

      GMF_PERIOD_STATUSES:

      INNER Join (cm_cmpt_dtl)

      Load CALENDAR_CODE,

      PERIOD_ID,

      PERIOD_CODE

      FROM [LIB://QVD/gmf_period_statuses.qvd] (qvd);

       

      Now i want to have a composite key LIKE

       

      PERIOD_CODE&'~'&INVENTORY_ITEM_ID in GMF_PERIOD_STATUSES table


      Regards,


      Zahid Rahim