How to remove rows where a column has a specific value?

Modified on Mon, 12 Dec 2022 at 04:39 PM

If you want to remove rows where one of the columns has a specific value (e.g. 0), do the folling steps:

  • Click on the step Transform > Filter Numeric
  • Select the desired column
  • Select the Operation !=
  • Enter the desired value (e.g. 0)
  • Click Apply.

You can choose whether to overwrite the existing dataset or output a new dataset with the rows removed.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article