3 Replies Latest reply: Jan 17, 2017 4:34 AM by PAUL YEO RSS

    ApplyMap it is possible to add condition ?

    PAUL YEO

      Hi All

       

       

      How to recode by mapping with condition ?

       

       

      I have below script work fine , when SOURCE=Q_DOD_20167

       

       

      ApplyMap('MapGroup',GROUP_CLASS,'OTHERS') as [GROUP_CLASS_]

       

       

      So that i can achieve below :-

       

       

      When SOURCE = Q_DOD_2016 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-GL ( Correct )

       

      nOW When SOURCE = Q_FCKL09 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-GL ( Wrong )

       

       

      hOW TO MAKE SOURCE = Q_FCKL09 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-KL ?

       

       

      Hopw some one can advise me.

       

       

      For testing my QVW , pls unzip the file and copy all the file to C:\TEMP

       

       

      Paul