When to use switch and when to use filter rows
Switch is used when you want to route records to multiple outputs based on the value of a specific field (e.g., Department = HR, IT, Finance).
Filter Rows is used when you want to filter data based on a condition and split it into two outputs: True and False (e.g., Salary > 5000).
In short:
-
Switch → Multiple value-based outputs.
-
Filter Rows → Condition-based filtering with True/False outputs.
