Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Country will be become Primary key during this join.
Try like this
LEFT JOIN (Customer)
both the tables joined based on the Country.
Can try like this:
Table1:Load Countryfrom customertable
Left join (Table1)
Load Country,Latitude,Longitudefrom 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!
You can write script as,
From CustomerTable ;
From LatLng ;
Hope this will help you
Load * From customertable;
Load * From LatLng
Where Exists (Customer);
thanks for your responses !! I got it.
Kindly close the thread by selecting appropriate answer.
Thanks it worked finally !!