9 Replies Latest reply: Sep 24, 2014 4:25 AM by Mohit Sharma RSS

    Issue with If in load script at column level

    Angad Singh

      Hello Community,

       

      My understanding is that, for IF condition, wherever condition is satisfied, it comes out of the IF, but it does not seem like that.

      In below, I do not have Bname as column in the table, but the hardcode condition should actually skip the else aprt, but it is not.

       

      test:

      LOAD

      if('A'='A',Aname,Bname) as TName,

      * INLINE [

      Aname, Aqty

      Angad,2

      Singh,3

      ];

       

      This gives error that Bname column not found.

       

       

      Thanks,

      Angad