topic Join problem in QlikView

Join problem

Thu, 27 Oct 2011 14:23:50 GMT

hi all

i have two tables - one table contains the numbers 1 to 10, the other table contains the numbers 1 to 15. I am looking for a way to join those two table with the resulttable having the numbers 11 to 15.

Can someone help me out here ?

Thanks,

Join problem

its_anandrjs — Thu, 27 Oct 2011 14:28:59 GMT

Hi,

Join tables with join command like

Table1:

Load

NumberField

From data;

Join

Load

NumberField

From data;

Let me know about this

Rgds

Anand

Join problem

its_anandrjs — Thu, 27 Oct 2011 14:39:58 GMT

Hi,

If the number field name should be same in the both tables so there is no need to join then in qlikview it will automatically joins.

But otherwise you need to join them by prefix Join, innerjoin, Letjoin, Rightjoin.

Rgds

Anand