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
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)
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 : )
Thank you!
Another quick q, how would i exclude rows if there is 0 in a specific column? thank you
