Delete duplicates at specific field

[DoubleG]

Hey,

How can I get table without duplicate values at specific field??

Need delete duplicated rows ( second, third etc.) at id.apteki value field as like this picture (need delete red rows).

[JHuis]

What is you unique key?

[DoubleG]

Good Question.
I can add additional field where duplicate number needed to delete ( no idea how flag ( 1 for unique value, 2... for duplicate value) to remove rows):

[cristianj23a · Accepted solution]

Hello, use this code.

Create a test data where the dim field has duplicates in the "k" and "n" values.

Temp:

Load * Inline [

dim, Year,metric

a,2022,100

b,2022,110

c,2022,120

d,2022,130

e,2023,140

f,2022,150

g,2022,160

h,2022,170

i,2023,180

j,2022,190

k,2023,105

k,2023,109

n,2023,125

n,2023,164

];

NoConcatenate

Table:

Load Distinct dim as Dim,

firstvalue(Year) as Year,

     firstvalue(metric) as metric

Resident Temp Group By dim;

Drop Table Temp;

Regarts.