2 Replies Latest reply: Oct 6, 2018 7:44 AM by Ian Tsang RSS

    not right

    DN WEB

      Hi team,

       

      Could you please look into the below

        • Re: sequence not right
          DN WEB

          any help

            • Re: sequence not right
              Ian Tsang

              Your YearMonth column is text. Try using the Dual function which will allow you to sort it by the numerical value:

               

              tests:
              LOAD
                *,
                Dual("Year" & '-' & "Month", Date) as YearMonth;
              
              LOAD
                  SalesAmnt,
                  Type,
                  Month,
                  Year,
                  Date(Date#('01/' & Month & '/' & Year, 'dd/MMM/yyyy')) as Date
              FROM [lib://folder/RSA Test.xlsx]
              (ooxml, embedded labels, table is Sheet1);