Recycling SQL in Qlik

[#1]

Hi there,

I am a complete Qlik newbie (I literally got it today). I'm basically testing something in both Tableau and Qlik to work out which platform is going to work better for us. In Tableau, I'm easily able to load the data I want using an SQL statement. However, I can't for the life of me work out how I can recycle that same statement in Qlik. I played around with the model that Qlik creates through automatic associations but it's just not going to cut it for what I want. So, here I am. How do I recycle the following existing SQL statement into something for Qlik?

SELECT EOY_DS_RR.*, EOY_DS_RESOLUTION.*, DATE_OPTIONS.*

  FROM (PVT_IDM_CMP_DATA.EOY_DS_RESOLUTION EOY_DS_RESOLUTION

        LEFT OUTER JOIN PVT_IDM_CMP_DATA.DATE_OPTIONS DATE_OPTIONS

           ON (EOY_DS_RESOLUTION.RES_DT = DATE_OPTIONS.ACTUAL_DATE))

       LEFT OUTER JOIN PVT_IDM_CMP_DATA.EOY_DS_RR EOY_DS_RR

          ON     (EOY_DS_RESOLUTION.SCID = EOY_DS_RR.SCID)

             AND (EOY_DS_RESOLUTION.RES_DT = EOY_DS_RR.DERIVED_DEPARTURE_DT)

UNION ALL

             SELECT EOM_DS_RR.*, EOM_DS_RESOLUTION.*, DATE_OPTIONS.*

  FROM (PVT_IDM_CMP_DATA.EOM_DS_RESOLUTION EOM_DS_RESOLUTION

        LEFT OUTER JOIN PVT_IDM_CMP_DATA.DATE_OPTIONS DATE_OPTIONS

           ON (EOM_DS_RESOLUTION.RES_DT = DATE_OPTIONS.ACTUAL_DATE))

       LEFT OUTER JOIN PVT_IDM_CMP_DATA.EOM_DS_RR EOM_DS_RR

          ON     (EOM_DS_RESOLUTION.SCID = EOM_DS_RR.SCID)

             AND (EOM_DS_RESOLUTION.RES_DT = EOM_DS_RR.DERIVED_DEPARTURE_DT)

Thanks in advance for any assistance you can offer

[tomasz_tru]

You have to create ODBC connection first (right side of script editor screen). Then you could add a connection to the script - something like:

LIB CONNECT TO 'MY ODBC CONNECTION NAME';

Then you can query using SQL statement:

SQL SELECT (...) ;

[tomasz_tru]

Did it help?