How to delete a row when the Condition is not satisfied

Question

I am new to Alteryx and struggling to find answer for deleting a row if the condition is not met and the condition should be checked only for specified values in the below conditions and after checking the condition the data set should include all other values for those condition is not applied and should also include the values that satisfy the mentioned condition only. I will be grateful if anyone helps me on this.

These are the conditions and I have attached the dataset

* 115 prediction should be less than -4200
* 213 prediction less than -700
* 126 prediction should be between -400 to -700

Thanks in Advance

metric_data.csv

Sadi44 · Answer

Emmanuel_G

Thank you for you reply, but in the formula tool you are using boolean or it gives value if any one of the condition is satisfied but I want the output with all the three conditions to be satisfied at once. And later it should include include model id's for those id's which are being satisfied by these three conditions with the id's 115,213,126 along with other id's with model id's that are being satisfied by those conditions

Emmanuel_G · Answer

@Sadi44

What I suggest is to add a status column that defines whether or not the 3 conditions are met (Last column on the right in the screenshot).

So you will keep all the lines. You can then filter or not if you want based on this column.

Is it ok for you ?

How to delete a row when the Condition is not satisfied.yxmd

Sadi44 · Answer

@Ladarthure

Thank you for your reply, but that is not the output I want. Can you please try like this, if the three conditions are not satisfied then the model id's for other ID's should also be eliminated and remaining model ids should be included for whatever id the conditions are satisfied