4 Replies Latest reply: Jul 4, 2018 9:59 AM by Gabor Tarnoczai RSS

    Month No to Month Name

    Valeta Isaacs

      Hi Everyone,

       

      Please can you assist, I need to change the field "MT NO" in below to return the Month Name and not the Month No.

       

      LOAD

          "YR SEASON CODE" as "Year Season Code",

          "MT NO" as "Month",

          "WK NO" as "Week No",

          "YR NO" as "Year"

      FROM [lib://QlikData.qvd]

      (qvd);