Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table1:-
LOAD PRIMARYKEY,
*;
SQL SELECT * FROM YADA;
LEFT JOIN (Table1)
LOAD PRIMARYKEY,
*;
SQL SELECT * FROM BING;
Table2:
LOAD NetWorkDays(OSD-AD),
*
RESIDENT Table1;
Drop Table1;
Thanks, just a couple of more questions:
What is the syntax for the PRIMARY KEY above? When I do my SQL join, it's on the field OM.RecID=CA.LOPRecID. So for the first table is it just "LOAD RecID, *" or do I need to give it a field name?
Also, normally, I put my table names AND my LOAD statements BEFORE the Select statement. Do I put this third LOAD statement AFTER the entire SELECT statement for CATable (i.e. after the FROM and WHERE clauses in the SELECT)?
Thanks!
Qlikview joins on Like Named fields, the above was just an example since I do not know your dataset
Table 1:
Field A, Field B;
Table 2:
Field XYZ AS Field A (differently named field but is really the same as field A above)