topic Re: Translate more than one join in sql to QlikView Script in QlikView

Translate more than one join in sql to QlikView Script

Anonymous — Fri, 26 Sep 2014 13:18:27 GMT

Hi guys, i have one sql query like:

SELECT A.*, B* FROM A INNER JOIN B on ... LEFT JOIN C on ...

But i have allready these three tables on qvd files. So i want to eliminate that sql query, creating just a script that make the same joins, but reading from my qvds. How should i do that? I thought this solution, but the results was not the same of the sql query:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

LEFT JOIN

LOAD ID FROM C.QVD

Re: Translate more than one join in sql to QlikView Script

anbu1984 — Fri, 26 Sep 2014 13:22:33 GMT

A_B:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

LEFT JOIN(A_B)

LOAD ID FROM C.QVD

Re: Translate more than one join in sql to QlikView Script

Anonymous — Fri, 26 Sep 2014 13:28:40 GMT

Hi Danilo,

Try below codes:

INNER:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

NoConcatenate

LOAD * Resident INNER;

LEFT JOIN

LOAD ID FROM C.QVD;

or you can try:

INNER:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

NoConcatenate

LEFT JOIN(INNER)

LOAD ID FROM C.QVD;

Hope it helps.

Regards

Nitha

Re: Translate more than one join in sql to QlikView Script

Anonymous — Fri, 26 Sep 2014 14:03:06 GMT

Thanks ANGU for your answer... but it gave me the same results...

Re: Translate more than one join in sql to QlikView Script

Anonymous — Fri, 26 Sep 2014 14:05:02 GMT

Thanks Nitha for your answer... but it gave me the same results... and the last solution you gave me alerted an error: WRONG COMBINATION. I think we can't use Noconcatenate together with JOIN

Re: Translate more than one join in sql to QlikView Script

anbu1984 — Fri, 26 Sep 2014 14:09:52 GMT

Is join key columns have same names in all tables?

Re: Translate more than one join in sql to QlikView Script

PabloOrtiz — Fri, 26 Sep 2014 17:51:22 GMT

Hi Danilo, try this:

Table1:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

Table2:

LOAD ID FROM C.QVD;

noconcatenate

Table3:

load * resident Table1;

left join (Table1)

load * resident Table2;

drop table Table1;

drop table Table2;

Re: Translate more than one join in sql to QlikView Script

Anonymous — Fri, 26 Sep 2014 18:21:58 GMT

Hi Danilo,

Can you explain in detail what output you need?