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

    Where clause

    Priyanka Pandey

      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.

       

      Regards,

      Priyanka