topic Re: Join in QlikView

Join

nikhilgarg — Thu, 05 Mar 2015 11:23:38 GMT

I have 3 tables.

I put:

Table 1 Right Join Table2;

Table3 Right Join Table 2;

Now how can i make output of Table1 (right join) output of Table3 ?

thanks

Gysbert_Wassenaar — Thu, 05 Mar 2015 11:29:21 GMT

Table1:

LOAD * FROM Source1

right join (Table1)

LOAD * FROM Source2

right join (Table1)

LOAD * FROM Source3

nikhilgarg — Thu, 05 Mar 2015 11:35:08 GMT

Hey,

I mean :

Table1:

LOAD * FROM Source1

right join (Table1)

Table2:

LOAD * FROM Source2

then i do

Table3:

LOAD * FROM Source3

right join (Table2)

LOAD * FROM Source2

Now , how can i do Resultant Table1 right join Resultant Table3 because i think i have to reload all data again ?