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 variable or literal parameters 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.
Export as PDF
Copy link