Script - Not Match - Skips Null Values

peterkumar — Fri, 02 Apr 2021 08:26:06 GMT

Hello,

I am loading data which has null values for the CRITICALITY field.

Null values are being skipped in the 'Not Match' function.

How do I include the null values and only skip 'C' and 'E' ? - see below.

Thanks,

Peter

Where
Not Match (CRITICALITY, 'C ', 'E')

Re: Script - Not Match - Skips Null Values

peterkumar — Tue, 05 May 2020 17:27:40 GMT

Solved it by using 'Not Like' instead of Not Maatch

where

//Not Match (CRITICALITY, 'C ', 'E')

(Not CRITICALITY like 'C' and Not CRITICALITY like 'E')