4 Replies Latest reply: Mar 25, 2015 8:46 AM by Priyanka Pandey RSS

    Where clause

      Hi Team,


      I want to remove rows that contain name field which is either null or blank or unknown or - during load time.

      I tried to use where clause in the script editor while loading the table.

      all the condition works fine except '-'


      Where [Student Name] <> '-' or [Student Name]= ' ' or [Student Name] = 'Unknown' or [Student Name]= 'null' ;


      please guide me for the same.