All you need to do is to change the 'where' line to this | fillnull Header value="Others"
| where match(Alert_Header, Inclusion) AND (Exclusion="NONE" OR !match(Alert_Header, Exclusion)) OR match(Header, "^Others$") This is saying make all Header values that are null, the word "Others" Add an extra test to include the row is that header is exactly Others The reason why it's excluded is that criteria is null for the non matched mappings, hence the expanded variables Inclusion/Exclusion/Header are then null, so for this specific case, you then fix it up at the end.
... View more