Remove rows after a specific text

[janety0127]

Hi,

I have a dataset for which I need to remove all rows after a specific word for example, after "total", I need all the rows filtered out or removed. How can I accomplish this?

[Qiu]

@janety0127 
Filter and Append tools can help with that.

Appreciate if you would mark this as accepted if it is useful for you.

[janety0127 · Accepted solution]

I actually searched a bit and found the solution:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-filter-records-after-a-cer...

Thank you!

[Qiu]

@janety0127 
Thats very nice.

And you can still accept my solution if it helps😁