Hi @Kinetic_analytics,
If I'm understanding your questions correctly, Alteryx cannot differentiate between a city name and the suffix of a company (LLC, Ltd. Inc., L.P. etc.). The best you can do is create a list of either your cities, or your company suffixes and then filter based on that list.
As an example, if I know all my company suffixes, I would the Custom filter configuration for the Filter tool with the following query:
[Field1] NOT IN ('LLC', 'Ltd.', 'Inc.', 'L.P.')
Alternatively, you could either load the suffix list as either it's own input (such as an Excel file), or typed directly into a Text Input tool and use a Join to apply the filter.
