There is left outer join in qlik. Syntax used is just Left Join.
And to join you don't need any on condition. Use aliasing to give the corresponding fields same name and it will join the tables on that particular column.
WORKFLOW_ID as WORKFLOWID,
You have LEFT OUTER JOIN in Qlik. Here is an example from Help, also read link
LOAD * from file1.csv;
LOAD * from file2.csv;
.. .. ..
join (tab1) LOAD * from file3.csv;
Hope it helps
You can use left join.
Ps: u can always use ur sql query directly in qlik ! If ur familiar with joins using sql, u can always keep on using them.
In fact, when u load a table in qlik:
u'll have 2 parts:
In the load part, u use qlik's functions;
in the select part, u use ur db functions.
what I mean, is that u can create ur joins as u're doing in the select part; then load * without further transformations.
Hope that was clear
If you don't Use a specific type of join (explicitely defined) Qlik will do the join by homonym, it will search for 2 fields with the same name, and it will do an OUTER JOIN,
example, if you do like this:
WORKFLOWID as WORKFLOW_ID
FROM RESTISSUE QVD;
WORKFLOW_ID //(or rename this field to WORKFLOWID )
FROM WORKFLOW QVD;
==> you will have your tables joined by the field WORKFLOW_ID , and you will have the records of both tables in your model.