4 Replies Latest reply: Aug 9, 2018 2:52 PM by Nicole Smith RSS

    multiple THEN in IF statement

    Глеб Аитов

      Hi,

       

      Quite a simple questions i think but i didn't find an answer.

       

      in the load script is is correct to have one IF for multiple THEN?

       

      Test:

      NoConcatenate


      Load

          if(status=6,1,0) as status,

          if(status=6,200,300) as revenue,

          if(status=6,'Y','N') as cancel_flag


      RESIDENT MyTable;


      Thank you!