Drop duplicates and advanced

Drop duplicates

Dropping duplicates allows for you to combine and collapse the rows in your table. By turning this option on, all records that are identical in all variables in the Keep section (of the variable selector at the top of the transform) will be collapsed into one record.

Limit rows and order output table

You can limit the size of the output table by an integer number of rows. Note that this will not reduce the compute cost of your query, but it may execute faster and will reduce the storage cost of your output table.

For example, we can ensure our output table only has the first 10000 rows, according to the ordering specified above.

You are also given the option to order rows on one or more variables in your output table. For example, we can sort our output table rows alphabetically by provider_name using the Low to high option.

‚Äč