Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Left Join Help !!

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.

1 Solution

Accepted Solutions
amit_saini
Honored Contributor III

Re: Left Join Help !!

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,

AS

8 Replies
MVP
MVP

Re: Left Join Help !!

Hi,

Try like this

Customer:

LOAD

*

FROM Customer;

LEFT JOIN (Customer)

LOAD

*

FROM Latlng;

both the tables joined based on the Country.

Regards,

Jagan.

Not applicable

Re: Left Join Help !!

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!

amit_saini
Honored Contributor III

Re: Left Join Help !!

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,

AS

vijetasharma
Contributor III

Re: Left Join Help !!

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

MVP
MVP

Re: Left Join Help !!

Load * From customertable;

Load * From LatLng

Where Exists (Customer);

Not applicable

Re: Left Join Help !!

thanks for your responses !! I got it.

MVP
MVP

Re: Left Join Help !!

Kindly close the thread by selecting appropriate answer.

Not applicable

Re: Left Join Help !!

Hi Saini,

Thanks it worked finally !!

Community Browser