Distinct

In this document, you’ll learn how to use the Distinct transformation in Astera Dataprep to remove duplicate rows based on selected columns, ensuring your dataset contains only unique records.

1. To apply Distinct in Astera Dataprep, click on the Transform option in the toolbar and select Distinct from the drop-down.

1. Once selected, the Recipe Configuration – Distinct panel will open.

• Column Names: Here, you can select one or more columns from the drop-down. The uniqueness check will be applied based on the selected columns.

1. After selecting the columns, click Apply.

2. Now, in the grid, you can see that only unique records, based on your selected columns, remain in the dataset.