How to create link between two table

[#1]

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

11         

11

11

22

11

22

33

33

44

44

55

55

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

Regards,

Rahul

[Anonymous]

Rahul

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

Best Regards,     Bill

[#3]

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]

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