Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm loading data from ODBC into Qlik Sense. My question is:
I have Table1 with columns A,B, Table2 with columns A,D. I want to left join Table2 on Table1 by column A, and show column B and D.
The SQL query is like:
SELECT T1.B, T2.D
FROM Table1 T1 LEFT JOIN Table2 T2
ON T1.A=T2.A
But this query doesn't work in Qlik Sense data load editor. How can I fix it?
Thanks in advance!
Thanks!