31 Replies Latest reply: May 19, 2016 11:06 AM by Sunny Talwar RSS

    How can I write an If statement for a Drop Field statement like this?

    John Blomqvist

      Hi all,

       

      I am trying to write a query like below:

       

      TableA:

      LOAD

      floor(RAND()*17)+10 as Test,

      1 as Counter

      AutoGenerate 23;

       

      If($(vDropField)=1, Drop Field Counter, False);

       

      Basically I want to drop the field is the vDropField variable contains 1, else don't drop the field.

       

      It doesn't work when I write it. Any idea how to do this please?