There are a number of ways to ignore or remove rows when working in Data Prep, but we recommend a combination of Mapping Groups and the Smart Filter Pipeline transformation.
Here's how it works:
- Chose a keyword -- such as Ignore -- to indicate field values that should be removed from the dataset. As necessary, utilize this keyword in Mapping Groups as a To value.
- Configure the smart filter transformation to remove matching rows when any mapped field equals the keyword (i.e., "ignore"). Be sure to use an OR condition in the Rule section of the conditions of the smart filter.