Remove Duplicates
Deduplicate a table based on a passed-in composite key. Once an order column and an order method are selected, only the top record from the resulting grouped and ordered dataset will be kept.
Parameters
Name | Type | Description | Is Optional |
---|---|---|---|
natural_key | column_list | Columns forming the grain at which to remove duplicates | |
order_col | column_list | Columns by which to order the result set, such that the first result is kept | |
order_method | sort_direction | Sets the order behavior for the chosen |
Example
Source Code
Last updated