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:




      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?