2 Replies Latest reply: May 25, 2017 2:14 AM by Tomasz Truszkowski RSS

    Recycling SQL in Qlik

    Deidre Penhaligon

      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