Model Qlikview

[emteam162]

Hi everybody,

I have two tables that I want to connect each other particularity that the links between these tables are the following fields

id, fk1 and fk2

table1

id	dim1	dim2
1
2
3
4
5
6

table2

fk1	fk2	dim3	dim4
1
2
3
4
5
6

the resultat :

Look enclosed

how i can do that

Many thanks,

Said

[Gysbert_Wassenaar]

rename fk1 to id

[richard_chilvers]

Do you mean that you link table 2 to table 1 by joining fk1 and fk2 together, and matching to id ?

[emteam162]

yes

fk1=id

and

fk2=id

[squeakie_pig]

This is a useful thread for understanding different ways to 'join' tables.  You may not necessarily need a traditional join to get the result you want

Understanding Join, Keep and Concatenate

[emteam162]

Please, any idea

[agomes1971]

Hi,

read this

Link Table in QlikView – Learn QlikView

HTH

André Gomes

[maxgro]

it seems you only want to "conect" when

fk1 = id  and fk2 = fk1

id     fk1     fk2               join?

1     1          1               yes

1     1          2               no

1     2          1               no

1     1                           no

is that what you want?