topic Re: How to create link between two table in QlikView

How to create link between two table

Mon, 26 Jan 2026 18:19:17 GMT

Dear All,

I have 2 table :

Table A:

XX Market

11 AAA

22 BBB

33 CCC

44 DDD

55 EEE

AND

Table B:

XX Market

So I want to create a link between two table by which I can see all market come in Table B .

Regards,

Rahul

Anonymous — Fri, 22 Nov 2013 09:31:02 GMT

Rahul

I would do a Mapping Load and ApplyMap() to add [Market] from [Table A] into [Table B].

Best Regards, Bill

Fri, 22 Nov 2013 09:40:55 GMT

Hi Rahul,

If this is the exact scenario then no need of links between these tables since market in Table B doesn't have any value.

So you can use Table A as it is.

If the above is not the exact scenario, please post your queries in a detailed manner with the exact requirement

Vinoth

er_mohit — Fri, 22 Nov 2013 10:00:21 GMT

try to use applymap

Map:

mapping load XX ,

Market

from table A;

load XX,

applymap('Map',XX,'#N/A') as MArket

from Table B;

hope it helps