This content has been marked as final. Show 4 replies
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.