Flag

[hi2019]

Hi - opened a new question due to needing a different variation

-need plz with 

if field does not have valid 2 character state code - I have STATE keyword list so if they are not in that list to flag /filter

The State is coming as abbr. already, TX,  CO etc. so I need to just a filter or not equal to or CONTAINS - what would best route to identify the states that should not be there

thanks

[Raj]

@hi2019 
please share sample input and expected output.
will be in better position to help.

[Hub119]

If you already have a list built of all valid state abbreviations, the easiest way to do this would likely be to utilize a join tool, joining on the state abbreviation field.  Where the data joins it is valid, and anything that kicks out the left or right output (depending upon how your two inputs are configured) would be your records that do not contain the proper abbreviations.