I have 2 table :
So I want to create a link between two table by which I can see all market come in Table B .
I would do a Mapping Load and ApplyMap() to add [Market] from [Table A] into [Table B].
Best Regards, Bill
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
try to use applymap
mapping load XX ,
from table A;
applymap('Map',XX,'#N/A') as MArket
from Table B;
hope it helps
Retrieving data ...