Distinct Node

Use the Distinct node to remove duplicate rows. By default, all the columns will be used to compare rows, to decide if there are duplicate values.

Subset: you can choose to compare only a subset of columns.

If a subset of columns are not defined, this node will only remove rows where every column is identical to another row

select distinct *
from {data_source}

Updated on: 05/10/2024

Was this article helpful?

Thank you!