CDS views , partially overlapping data

[Former Member]

Hello Experts,

     I am working with CDS views. I want to select specific row from several partially overlapping data,  for example.

Origin data:    

Field 1	Field 2	Field 3	Field 4
1	aaa111	bbb111	R1
1	NULL	bbb111	R2
1	aaa111	NULL	R3
1	NULL	NULL	R4
2	NULL	bbb222	R5
2	aaa222	NULL	R6
2	NULL	NULL	R7
3	aaa333	NULL	R8
3	NULL	bbb333	R9
4	NULL	bbb444	R10
4	NULL	NULL	R11
5	NULL	NULL	R12

After select:

Field 1	Field 2	Field 3	Field 4
1	aaa111	bbb111	R1
2	aaa222	NULL	R6
3	aaa333	NULL	R8
4	NULL	bbb444	R10
5	NULL	NULL	R12

          Since cant use sub-query or "order by" clause, so..., How can I do.

[P1389307362]

Hi,

First take distinct values of column 1 and put a left outer join for other columns

https://help.sap.com/saphelp_hanaplatform/helpdata/en/b4/080c0883c24d2dae38a60d7fbf07c8/content.htm#...

[henk_verdaasdonk4]

Hi Kang,

I don't understand the exact requirement. Why is record R6, R8, etc. selected, on what logic?

Or is just random 1 record out of the set 2 and 3? So it could as well have been records R1, R5, R8, R10, R12?

Cheers,

Henk.