mapping tables

[#1]

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.

[#2]

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