Efficient way to filter and then delete if conditions are present using formula function

thalil

Hello, 

I am trying to filter certain conditions in my workflow so that if the data contains the stated condition it is deleted. For example, if in the 'journal description' column of the data it states "Revalue Revaluation Result" then I would like to remove this from the data. 

I am currently using the filter function to perform this task (If it does contain this then this is grouped to the true output of the filter function). The custom filter I am using is working, however I was wondering if there was a more efficient way to include these filters, possibly using the formula function since I have more conditions to include. A 'contains and then delete' formula would be useful. Is there are more efficient way or would I keep using filter functions off of the 'false' branch of the previous output. 

Attached is the current custom filter as well as some of the workflow. Please let me know. 

Thank you 

Capture.PNG

cjaneczko

Filter is probably the best method. You can include multiple statements in the Filter tool using a combination of AND/OR. And if you want it to show the correct data on the True side change your formula to != instead. It will put the correct flow of data on the True side instead of the False side.