4 Replies Latest reply: Jun 5, 2017 1:24 PM by Sunny Talwar RSS

    NOT MATCH Function Acting Weird

    Alexander Grando

      Hi,

       

      I am using a NOT MATCH function to filter out certain asset types:

      If(NOT MATCH(AssetType, 'Garage', 'Retail', 'HOA'), 'Yes') as Included

       

      The weird thing is that the function is also partially excluding those records with a blank or NULL value as AssetType. But it is not excluding all of them, only about half. Another weird thing is that if I replace AssetType with 'MISSING' instead of blank/NULL earlier in the script then it works fine:

      If(Len(AssetType) = 0, 'MISSING', AssetType) as AssetType

       

      Can anyone shed some light on why the NOT MATCH function is behaving inconsistently when it comes to blank or NULL values, please?