topic SQL QUERY Converter in QlikView

SQL QUERY Converter

Mon, 08 Sep 2014 10:06:45 GMT

HI All,

I have the query as below and I need to convert it into QV. Can anybody have a look into this

Select DBO.CASE_END2END.ACCOUNTABILITY_ID,
    DBO.CASE.CASE_ID,
    DBO.CASE.CL_Date_GMT,
    DBO.SUBCASE.SubCase_ID
from DBO.CASE
left join DBO.SUBCASE on DBO.CASE.ACCOUNTABILITY_ID = DBO.SUBCASE.ACCOUNTABILITY_ID
WHERE DBO.CASE.ACCOUNTABILITY_ID = '464921';

Thanks,

Chiru

Re: SQL QUERY Converter

alexandros17 — Mon, 08 Sep 2014 10:13:59 GMT

Select DBO.CASE_END2END.ACCOUNTABILITY_ID,
DBO.CASE.CASE_ID,
DBO.CASE.CL_Date_GMT
from DBO.CASE
WHERE DBO.CASE.ACCOUNTABILITY_ID = '464921';

left join

Select DBO.SUBCASE.ACCOUNTABILITY_ID
DBO.SUBCASE.SubCase_ID
from DBO.SUBCASE;

But you can run the first in qlik as it is.

Re: SQL QUERY Converter

IAMDV — Mon, 08 Sep 2014 10:27:11 GMT

Something like this...? Where you extract the data from both tables and join predicate will be ACCOUNTABILITY_ID. I assume that ACCOUNTABILITY_ID is available in both the tables.

Case_Table:

LOAD *;

Select

DBO.CASE.ACCOUNTABILITY_ID

    DBO.CASE_END2END.ACCOUNTABILITY_ID,
    DBO.CASE.CASE_ID,
    DBO.CASE.CL_Date_GMT,
    DBO.SUBCASE.SubCase_ID
from DBO.CASE

WHERE DBO.CASE.ACCOUNTABILITY_ID = '464921';

left join (Case_Table)

LOAD *;

Select

DBO.SUBCASE.ACCOUNTABILITY_ID

DBO.SUBCASE.SubCase_ID

from DBO.SUBCASE

I hope this helps!

Cheers,