You can use the "Filter Rows" tile in Magic ETL to get rid of rows that you don't need.
Filter rows in Magic ETL gives a new dataset with the filtered rows but doesn't delete it from the input dataset. I am trying to update the input dataset.