Hello
I have two ODSs whose structure is as mentioned below.
ODS-1
-
A(Key) B(Key) C(Key)
-
01 01 X1
01 01 X2
ODS-2
-
A(Key) B(Key) D(Key)
-
01 01 Y1
01 01 Y2
C & D column values will be multiple in their respective ODS2 and there is no relation ship between them.
My report requirement is as shown below. X2& Y2 values are under C & D columns.
-
A B C D
-
01 01 X1 Y1
X2 Y2
If I creaet a infoset on above two ODSs by joining fields AB. I am getting result as shown below. X1&X2 are under C and Y1,Y2 are under D column.
-
A B C D
-
01 01 X1 Y1
Y2
X2 Y1
Y2
I will be glad, if you can guide me to resolve this.
Regards
MB