4 Replies Latest reply: Nov 18, 2013 6:25 AM by Shashank Seth RSS

    concat problem in script

    Shashank Seth

      Hi Geniuses,

       

      When I am concatenating 20 with one column it gave me wrong result. Below is the script

       

      LOAD 

          '20' & Right([Fiscal Year],2) AS FY ,

           [Fiscal Year]

       

       

      FROM

      [..\..\QVD_DATA\ETG\S_E_Bookings.qvd]

      (qvd)

       

      where Fiscal Year is FY10, FY11,FY12,FY13

       

      The desired result is 2010,2011,2012,2013

       

      Result which I am Getting 20,2010,2011,2012,2013

       

      I want to remove that unwanted 20

       

      Thanks in advance

       

      S