Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using two tables table A and Table B.
Table A contains below fields.
A,B,C
Table contains
D,E
I want to join this two tables with inner join.
Like Columns E from table B inner join with column A or column B from Table A.
How to write or condition while doing inner join?
Qlik does a natural join which means that the fields that are going to be matched have to have the same names so you don't use an ON clause like in SQL or a SQL WHERE-clause (if you use old-style joins).
You can still use a WHERE-clause for anything that is not meant to match / join the two tables.
Qlik does a natural join which means that the fields that are going to be matched have to have the same names so you don't use an ON clause like in SQL or a SQL WHERE-clause (if you use old-style joins).
You can still use a WHERE-clause for anything that is not meant to match / join the two tables.