3 Replies Latest reply: Mar 14, 2018 5:38 PM by Manish Kachhia RSS

    If statement in load script

    Yvonne Han

      Hi

       

      I'm use an "if statement" to check a condition in load script, but I got this syntax error 

       

      this is the if statement:

      IF count([Calendar year])= 0 THEN

      DROP TABLE Data;

       

      Else

      Load data…

      ENDIF

       

      The error I got is :

      Unexpected token: '=', expected: 'THEN'

      IF (count([Calendar year])>>>>>>=<<<<<< 0) THEN

       

      I also tried to put count([Calendar year])= 0 inside (), but still getting the same error.

       

      any idea why?

       

      Thanks

       

      Yvonne