5 Replies Latest reply: Aug 20, 2015 9:31 AM by Steve Dark RSS

    how to make given code as optimized load

    vir vir

      GS:

      LOAD  [BID]

      Resident Book;

       

       

      Left Join

      LOAD

        [BID],

               if([Sequence Number]>1, 'Company', 'broker') as [ Type],

        [Address 1],

        [Address 2],

          

            len( [Email Adrress]) as [Email Length]     

      FROM

      $(vQvdFileLocation)guest.qvd

      (qvd)

      WHERE ([ Year] >= $(vFromYear) and [ Year] <= $(vToYear));