How to suppress doublets in custom CDS view?

[former_member596578]

Dear experts,

I am facing the following situation:

For some reason (propably due to multiple languages of code list fields) am I able to identify certain doublets in a multi layer custom CDS view I created (on the basis of other custom CDS views that do not contain doublets - at least not that I am aware of).

These doublet lines in the table are always completely similar to each other, which means if there was a way to just eradicate every instance of an UUID (for example) after the first one, then the CDS view would fulfill it's requirements adequately.

How can this be achieved?

Thanks and kind regards,
Nils

[ThorstenHoefer]

Hi n.walter,

you can suppress doublates with

select distinct ....

[former_member596578]

Hi Thorsten,

where and how do I use this "select distinct"? Is this a command in the calculation of elements or something else?

BR

Nils