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!!

[joshuaburkhow]

There are going to be many ways to solve this. This is my 5 min solution that should get you started. Let me know if this doesn't work or you'd like me to walk through further. 

[JoeS · Accepted solution]

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:

[joshuaburkhow]

@JoeS solution is better because he's using the record ID which is unique to that set. Good job, totally missed that! haha