FLAG from list

[hi2019]

Hi 

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

thanks

[LindonB]

Try joining in a list of the state abbreviations to your data on the field with the abbreviation. Whatever comes out of the left output on the join will be the records that didn't have the valid state code. To filter, just ignore the left output. If you want to keep them in the data but flag them, then add a formula after the left output to add a tag, then union left and center together.

[binuacs · Accepted solution]

@hi2019 Find and Replace is another option

[hi2019]

Hi,

I want to flag the the ones that are not in the list

[binuacs · Accepted solution]

@hi2019 @If there is no match then the find and replace  field will have NULL values, using a formula tool you can create flag based on the NULL value. In the above example if the state name field is null means it is not present in the list of state values, you can test that removing few state code from the input file