CDS View - delete entries with duplicate key

[Former Member]

Hello,

does someone know if there is a way to remove entries that have the same key from a CDS View? Distinct or Group By actually removes only duplicate entries, not entries that have just a duplicate key. Is there a way to use the select "DISTINCT" on only the key fields?

Thank you and best regards,

Cristina

[former_member328158]

Hello Cristina,

I have the same issue.

Can you please provide the Source code of the solution ?

[sanju_joseph]

it is a combination of min and group by clause that does the filter, for example if i don't want to have business partner repeated for different role.
then i have to use

min ( tb003t.role ) as xyz and i should not use tb003t.role in group clause ,which is also the way above code works.