i want add link table between 2 tables in following scenario?

[#1]

load * inline

[

name,number

manoj,123

kumar,456

ravi,789

];

load * inline

[

name ,no

rakesh,222

mahesh,555

ravi,224

];

FOR EXAMPLE HERE I WANT CREATE A LINK TABLE HOW ? IS IT POSSIBLE INTHIS  SCENARIO? IF? PLS? URGENT

[#2]

i know join and concatenation if i want make a link table then how?     whether i have to use resident for both table and using concatenate to  join   ?

[#3]

For inline data like below renaming one of the fields should then join automatically. With the third column table you would be able to identify the 2 different Ravi entries, could create a calculated dimension in chart.

load * inline

[

name,number, tablename

manoj,123, first

kumar,456, first

ravi,789, first

];

load * inline

[

name ,number, tablename

rakesh,222, second

mahesh,555, second

ravi,224, second

];

[#4]

ok leave it i want know how to make link table between 2 tables  pls  give simple example with explination

[#5]

Hi Manojqlik,

Open a new workbook, save it now (saves you doing it in a few minutes)/

Add the script above into the script editor (Ctrl + E).

Reload the data. You'll go to a blank workbook.

To view the new table go to Table editor (Ctrl + T) and you'll see one table.

Add table object to see data.

Qlikview has a lot of "magic" behind the scenes.

All the best

[DavidFoster1]

Hi Manoj

A link table is a data modelling option used when you have multiple fact tables that share more than one dimension table. Without the link table then the model risks creating loop relationships not good.

Here is a good blog entry on link tables and concatenation options

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

To create a link table have a think about the fields that need to be in the link table and the field needed to create a single field relationship between the link table and the 'linked' fact tables.

[#7]

Hi Manoj,

When you have more than one fact table ,then you can use 2 methods,

First is Concatenation and other is LInk Table.

So,In your case,you can easily concatenate the tables just by renaming the second field in the second Table.

[#8]

for detail regarding Link Tables just follow the link:

http://www.quickqlearqool.nl/?p=910

[#9]

if i want make link table what keys i have to use  

i want syntax  i fell

load* inline                      load *

                                            from

                                                resident1;

[

.                                         concatenate

                                              load * from

                                               resident 2;

'

'

'

];

concatenate

load* inline

{

;

;

;

];    i feel this is the way to create link table instead of in line if we have table then we go for  resident