In the previous examples, we applied a filter and discarded the rows that didn't match a given condition. It may be the case that you don't want to discard any row. You might simply want to apply different treatments to the rows that match and those that don't match a particular condition. This can be accomplished in a simple way. Suppose that you want to separate the locations with private rooms from the rest of the locations:
- Create a transformation and read the files containing the surveys.
- After the input step, add a Filter rows step.
- Double-click the step and use it to create the Room_type = Private room filter.
- Drag two Dummy steps from the Flow folder to the work area.