6 Replies Latest reply: Mar 24, 2017 11:49 AM by Patrick routier RSS

    added text in load

    Patrick routier

       

      Hello,

      In the load function, I would like to test if my WEEK is with 2 digits and if not I would like to add a Zero before.

      The below expression doesn't work :-)

      someone could help me ?

       

      LOAD
      Year&
      if(len([Week]>1),[Week],'0'&[Week]) as ID_Temps,
      ...
      FROM ...

      Thank you in advance,

      Patrick