topic Join 2 tables but excluding elements from table 2 absent from table 1 in QlikView

Join 2 tables but excluding elements from table 2 absent from table 1

Thu, 15 Nov 2012 00:00:20 GMT

Hi again,

I'm trying to get data from a mysql table (customer ID / Mail_registration) and to get only results of customer ID that exist in my 1st table (taken from a csv):

I've tried a left join like this:

I have my master table above and then:

ODBC CONNECT TO idb01 (XUserId isxxxxxxxxxxxxx , XPassword is xxxxxxxxxxxxx);

LEFT JOIN (master)

SQL SELECT customerCode,

mailMagazineCode

FROM fujiyama.MailMagazineSubscriber;

But it seems like it's either duplicating the customerCode or doing something else because my sales appear more than twice as high as the "real" level.

Any idea on how to solve this ?

Thanks in advance !

Re: Join 2 tables but excluding elements from table 2 absent from table 1

Anonymous — Thu, 15 Nov 2012 10:17:13 GMT

Is customerCode enough to link both the tables? Should you have more specific key e.g. concatenate CompanyCode with customerCode?

Also try grouping your second table.

LEFT JOIN (master)

SQL SELECT customerCode,

mailMagazineCode

FROM fujiyama.MailMagazineSubscriber

GROUP BY customerCode, mailMagazineCode;

I hope this helps!

Regards

~MultiView

Re: Join 2 tables but excluding elements from table 2 absent from table 1

Thu, 15 Nov 2012 23:30:21 GMT

Let me give this a try. No need to concatenate anything I guess...

Thanks a lot !!!