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