topic Joins in Tables in QlikView

Joins in Tables

stuwannop — Mon, 10 Oct 2011 11:22:50 GMT

Hi All

I have two table that I want to join together. One is called "CRM Account" and the other is called "Account Spend".

My key field is going to be "accountno" which exists in both tables. However, there are various transactions in the "Account Spend" table that do not relate to any accounts in the "CRM Account" table. I want to exclude this data when I run the script as I am not interested in it - how do I do that in the script?

Thanks

Stu

Joins in Tables

SunilChauhan — Mon, 10 Oct 2011 11:28:07 GMT

load CRM Account table left join with Account Spent .

then it will take from CRM Account and matching from Account Spent

Joins in Tables

its_anandrjs — Mon, 10 Oct 2011 12:27:03 GMT

Hi,

You have to load data like

CRMTable:

Load *

From CRM

Join(CRMTable)

Load *

From Account Spent

where exists(accountno);

Rgds

Anand