topic Re: CDS views , partially overlapping data in Application Development and Automation Discussions

CDS views , partially overlapping data

Former Member — Thu, 18 Feb 2016 05:24:53 GMT

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 — Tue, 23 Feb 2016 11:17:42 GMT

Hi,

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

henk_verdaasdonk4 — Tue, 23 Feb 2016 15:01:59 GMT

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.