topic Re: Using Exist or Left Join in QlikView

Using Exist or Left Join

Fri, 24 Apr 2015 15:54:20 GMT

I have two resident table

Table 1 has a list of Controlling Areas

Key field is A

Table 2 has Controlling Area data

Key field is %$CO_Area

I want to create another table from Table 2 if the A exists in Table 2.

I tried

Resident Table 2

where exists(%CO_Area,A) ;

I am getting a syntax error that A does not exist.

buzzy996 — Fri, 24 Apr 2015 15:56:38 GMT

seems here A existing in Table1?right

Fri, 24 Apr 2015 15:59:26 GMT

Yes you are correct A is in Table 1, and I only want to pull data from table 2 if the CO Area is in Table 1

anbu1984 — Fri, 24 Apr 2015 16:00:45 GMT

Change order in Exists()

Resident Table 2

where exists(A,%CO_Area) ;

buzzy996 — Fri, 24 Apr 2015 16:01:36 GMT

can u try Applymap() here?

Fri, 24 Apr 2015 16:07:32 GMT

Change to have the Table 1 field prior to the Table 2 field worked.

Thank you