Filtering data

[Vighnesh_Ivaturi]

Hi. I have data that consists of entities and persons together. I need to filter the persons out of the data. I can't directly filter in it as there are many possibilities of entity types LTD, LLC, INC, etc. I also tried to use the Name entity recognition tool, but since the data is huge it's taking a lot of time. Please help me in solving the issue. I'm attaching the sample data. Thanks in advance.

[michelle_mathews]

@Vighnesh_Ivaturi , you could use the following filter. It should help filter out most, if not all, of the company names. 

Contains([AGENT],"CORP") OR
Contains([AGENT],"LLC") OR
Contains([AGENT],"LTD") OR
Contains([AGENT],"INC.")

[acarter881]

Hello @Vighnesh_Ivaturi.

Please see the attach workflow. I filtered out all corporations with one expression.

Spoiler

[Vighnesh_Ivaturi]

There are about 500 unique entity types in our data base, I cant hard code all of them. 

[DanFlint]

@Vighnesh_IvaturiIf you have a list of company identifiers, you could use the Find & Replace tool to append a flag and filter on that flag.

In my example this is just a text input, but could be driven from an external lookup

Hope this helps