Skip to main content Skip to complementary content

Join

The join prefix joins the loaded table with an existing named table or the last previously created data table.

Syntax:  

[inner | outer | left | right ]Join [ (tablename ) ]( loadstatement | selectstatement )

 

The join is a natural join made over all the common fields. The join statement may be preceded by one of the prefixes inner, outer, left or right.

Arguments:  

Table load arguments
Argument Description
tablename The named table to be compared to the loaded table.
loadstatement or selectstatement The LOAD or SELECT statement for the loaded table.

Example:  

Join LOAD * from abc.csv;

 

Join SELECT * from table1;

 

tab1:

LOAD * from file1.csv;

tab2:

LOAD * from file2.csv;

.. .. ..

join (tab1) LOAD * from file3.csv;

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com