Where clause

[#1]

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

[PrashantSangle]

Hi,

Try

Where not wildmatch([Student Name],' ','Unknown','null','-')

Regards

[#3]

Try with this

where not isnull( [Student Name ]) or [Student Name ] = 'Unknown' or len(trim([Student Name ])) <> 0

[#4 · Accepted solution]

Hi Priya, For '-' try to: Where not IsNull([Student Name])

[#5]

Thanks Francisco

It worked