16 Replies Latest reply: Nov 21, 2014 12:15 PM by O'Brian Newell RSS

    ApplyMap - How to map multiple tables?

    O'Brian Newell

      Hello,

       

      I am new to QV and need to lookup the rate from the FX table.

      My data is as follows:

       

      [FX]:
      MAPPING LOAD //Ccy AS CCY,
           Date AS DATE,
           RATE
           //(Ccy&Date) AS CCYDATE,
      FROM FX;

       

      [DATA]:
      LOAD DATE,
        TRADE,
           CCY,
           (CCY&DATE) AS CCYDATE,
           NOTIONAL,
           NOTIONAL/APPLYMAP('FX',DATE,'0') AS CONVERTED,
           APPLYMAP('FX',DATE,'0') AS RATE
      FROM DATA;

       

      The above works as I am able to return the values.

      However, in the FX table I have had to comment out two fields to meet the requirements of mapping.

      But would like to also include the other two fields.

      My question is am I able to map multiple tables?

       

      Many thanks in advance,

       

       

      O'Brian