mapping tables

Mon, 26 Jan 2026 18:19:17 GMT

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

22 100

11 500

22 400

33 700

33 300

33 100

11 400

22 600

AND

Table C:

XX MARKET Amount

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

Fri, 22 Nov 2013 10:12:05 GMT

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

TableC:

Load *,

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

Resident TableB

3) DROP Tables TableA, TableB

Fabrice

topic Re: mapping tables in QlikView

mapping tables

Re: mapping tables