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 order_col. Can be ASC or DESC.

Example

ds = rasgo.get.dataset(id)

ds2 = ds.remove_duplicates(
  natural_key=["FIPS", "DS_WEATHER_ICON", "DATE"],
  order_col=["DATE", "FIPS"],
  order_method="asc"
)
ds2.preview()

Source Code

RasgoTransforms/remove_duplicates.sql at main · rasgointelligence/RasgoTransformsGitHub