1 Reply Latest reply: Nov 22, 2013 5:12 AM by Fabrice Aunez RSS

    mapping tables

      Dear All,

       

      I have 3  table :

       

      Table A:

       

      XX          Market

      11          AAA

      22          BBB

      33          CCC

      AND

      Table B:

       

      XX          Amount

      11         100

      11          200

      11          200

      22          100

      11          500    

      22          400

      33          700

      33          300

      33          100

      11          400

      22          600

      AND

       

      Table C:

       

      XX          MARKET     Amount

      11        

      11         

      11         

      22         

      22         

      22         

      33         

      33         

      33         


      so i want to create a link between table by which I have Amount and Market come in Table C.

       

      Please reply soon

       

      Regards,

      Rahul.

        • Re: mapping tables

          Hi,

           

          First of all, at the end of the script you should delete the 2 tablesthat will not be used.

          You could test:

          TableB:

          LEFT JOIN

          LOAD *

          Resident Table A;

          It should add the extra column you want.

           

          If it does not work:

          1) TableA is it a MAPPING table ?

          if not

          MAP_TableA:

          MAPPING LOAD * Resident TableA

           

          2)

          TableC:

          Load *,

          ApplyMap('MAP_TableA', XX, 'Not Supplied')

          Resident TableB

           

          3) DROP Tables TableA, TableB

           

          Fabrice

          Fabrice