Excluding or deleting rows

[chiragpatel_1]

Hi, I have a data set in which I'm looking to delete rows based on if a column had the word 'cancelled in it. How do i do this? many thanks

[AngelosPachis · Accepted solution]

Hi @chiragpatel_1 ,

Try using a filter tool, and with the basic filter option selected, pick that column of interest from the first dropdown, then from the second drop down select "does not contain" and from the third text box, type "cancelled" (without the quotes)

[chiragpatel_1]

Thank you!

[chiragpatel_1]

Another quick q, how would i exclude rows if there is 0 in a specific column? thank you

[atcodedog05 · Accepted solution]

Hi @chiragpatel_1 

You can use combined conditions like below.

And condition: both needs to meet

[Field1]="cancelled" 
and
[Field2]=0

Or condition: either needs to meet

[Field1]="cancelled" 
or
[Field2]=0

Workflow:

Refer this interactive lesson https://community.alteryx.com/t5/Interactive-Lessons/Filtering-Data/ta-p/76301 

Hope this helps : )

[chiragpatel_1]

Thank you!