10 Replies Latest reply: Aug 14, 2017 5:29 PM by Marco Wedel RSS

    General if statement

    Mark Graham

      Hi,

      I'm trying to create a new fileds using and in if statement. But i'm not getting any result.

      But a simple if statement is not working. I know there should be something wrong in my syntax.

      Can someone please help?

       

       

       

       

      Table1:

       

      LOAD * Inline

      [

      ID, Name

      1,A

      1,B

      1,C

      1,D

      1,E

      ];

       

       

      Table2:

      LOAD *,

      If(Name='A' and Name='B' and Name='D' and Name='D' and Name='E' , 'special') as test

      Resident Table1;

       

      DROP Table Table1;