topic Re: Help with joins in QlikView

Help with joins

Thu, 01 Aug 2013 09:01:18 GMT

Hi,

I am trying to join two tables

Basically everything in table 1 is exempt so these people dont need to be shown. And table 2 has a list of everyone. Im trying to join the two tables So that the people who have exemption dont appear. Could someone advise how i go about doing this.

Thanks in advance,

Kind regards,

Natalie

Table 1 (Exempt)
First Name
Surname
Location

Table 2
First Name
Surname
Locations

Re: Help with joins

vikasmahajan — Thu, 01 Aug 2013 09:07:19 GMT

Select First Name,Surname,Locations

from table2

inner join table 1

where exempt < Condition>

Hope this helps

Vikas

Re: Help with joins

jvitantonio — Thu, 01 Aug 2013 09:47:17 GMT

Hi, please use the following code

t1:

LOAD

autonumber([First Name]&[Surname]&[Location]) as Key, [First Name], Surname, Location

FROM ...

t2:

NOCONCATENATE

LOAD

autonumber([First Name]&[Surname]&[Location]) as Key, [First Name], Surname, Location

FROM ...

WHERE NOT EXISTS (Key);

Drop Table t1;

I hope this helps.

Re: Help with joins

Thu, 01 Aug 2013 09:55:03 GMT

Hi, Thank you for your response i have just tried this but it comes up with a field not found - <Key> error

Re: Help with joins

jvitantonio — Thu, 01 Aug 2013 10:30:21 GMT

Make sure your field names are accurate. Otherwise please attach your application here so I can take a look at it.