Filtering out the rows based on multiple condition

bb

Hello,

I have a table with more than 2000 rows that has data that looks like below:

RecordID	Organization Group	Asset	Name	Value
2	Fruit	Apple	Database 1	Sql
2	Fruit	Apple	Database 1 Detail	Table
2	Fruit	Apple	Database 1 URL	Not Applicable
3	Vegetable	Potato	Database 2	Sql
3	Vegetable	Potato	Database 2 Detail	Oracle
3	Vegetable	Potato	Database 2 URL	Secured
4	Fruit	Oranges	Database 3	Sql
4	Fruit	Oranges	Database 3 Detail	Oracle
4	Fruit	Oranges	Database 3 URL	Good

If I want to only retrieve the rows that have "URL" on Name column and does not contain 'Not Applicable" and "Secured" in the Value tab. It should retrieve all the relevant rows to that particular asset. So my table should looks like this:

RecordID	Organization Group	Asset	Name	Value
4	Fruit	Oranges	Database 3	Sql
4	Fruit	Oranges	Database 3 Detail	Oracle
4	Fruit	Oranges	Database 3 URL	Good

Any help would be appreciated. Thanks!!

JoeS

Hi @bb 

You'll want to use the filter tool and go into the custom option with the expression being:

Contains([Name], "URL")
AND
!Contains([Value], "Not Applicable")
AND
!Contains([Value], "Secured")

Then get the unique list of RecordID's to join back.

Like:

FilterJoin.yxmd