on 01-22-2016 8:31 AM
Hello
My 3 source tables
Table 1 C1 C2
1 XX
1 AA
2 BC
3 DF
4 AB
Table 2 C1 C2
1 ABC
1 DEF
2 GHI
3 KJM
4 NOP
4 XYZ
Table 3 C1 C2
1 AAA
1 BBB
1 CCC
2 DDD
2 EEE
3 FFF
4 GGG
where C1 is column one and C2 is Column two.
I need the output as
Table 4
C1 C2 C3 C4
1 XX NULL NULL
1 AA ABC AAA
1 NULL DEF BBB
1 NULL NULL CCC
2 BC GHI DDD
2 NULL NULL EEE
3 DF KJML FFF
4 AB NOP GGG
4 NULL XYZ NULL
How can achieve this in DS, any assistance would be extremely appreciated
Thanks and regards,
Abhishek Biwal
Can you explain the requirement and logic?
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Arun,
The entire logic id for contact person load from BODS to MDG.
table one store, phones numbers
table two stores, fax numbers
table three stores, email id's
using these tables I need to map to one IDoc segment for contact person.
If the primary key repeats, that many segments will be created.
so I need the output as
Table 4
C1 C2 C3 C4
1 XX NULL NULL
AA ABC AAA
NULL DEF BBB
NULL NULL CCC
2 BC GHI DDD
NULL NULL EEE
3 DF KJML FFF
4 AB NOP GGG
NULL XYZ NULL
Thanks and regards,
Abhishek Biwal
User | Count |
---|---|
77 | |
8 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.