topic Re: Left Join Help !! in QlikView

Left Join Help !!

Tue, 22 Apr 2014 05:19:02 GMT

Hi,

I need to do Left Join for these tables.

My requirement is Country from left table and Latitude & Longitude from right table.

Let me know, how to do this in editor.

Re: Left Join Help !!

jagan — Tue, 22 Apr 2014 05:27:56 GMT

Hi,

Try like this

Customer:

LOAD

FROM Customer;

LEFT JOIN (Customer)

LOAD

FROM Latlng;

both the tables joined based on the Country.

Regards,

Jagan.

Re: Left Join Help !!

Tue, 22 Apr 2014 05:30:48 GMT

Can try like this:

Table1:
Load Country
from customertable

Left join (Table1)

Load Country,Latitude,Longitude
from LatLng;

By default the tables will be joined on Country. If you want all the fields then you can use * instead of particular field names.

Hope this helps!

Re: Left Join Help !!

amit_saini — Tue, 22 Apr 2014 05:56:30 GMT

Hi Murali,

Try this:

Table1:

LOAD *,

FROM

Customer_table;

Left Join(Table1)

LOAD *,

FROM

LatLong;

Country will be become Primary key during this join.

Thanks,

Re: Left Join Help !!

vijetas42 — Tue, 22 Apr 2014 06:05:45 GMT

Hi,

You can write script as,

CustomerTable:

LOAD Customer

From CustomerTable ;

LEFT JOIN(CustomerTable)

LatLng:

LOAD *

From LatLng ;

Hope this will help you

Regards,

Vijeta

Re: Left Join Help !!

MK_QSL — Tue, 22 Apr 2014 06:23:38 GMT

Load * From customertable;

Load * From LatLng

Where Exists (Customer);

Re: Left Join Help !!

Wed, 23 Apr 2014 06:19:32 GMT

thanks for your responses !! I got it.

Re: Left Join Help !!

MK_QSL — Wed, 23 Apr 2014 06:22:08 GMT

Kindly close the thread by selecting appropriate answer.

Re: Left Join Help !!

Wed, 23 Apr 2014 06:31:14 GMT

Hi Saini,

Thanks it worked finally !!