Filters

Filter rows

To specify conditions on which rows will be kept in the output table, click + Filter rows. You can specify a series of comparisons; on the left side, select from all available variables (including newly created variables), then choose a comparison operator, and on the right side provide any number of values and variables to compare against.

For example, we can select all records where provider_state is CA or AZ and where the average_total_payment is greater than 1000.

Filter partitioned rows

You can also filter rows generated after partitioned variables are created, using the + Filter rows button. The specification is similar to row filtering in the Build step, but you can also filter on any partitioned variables you created above.