Filters
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
.
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.
Last modified 1yr ago