Output data in same lines but not repeating

[abhishekbiwal]

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

[former_member198401]

Can you explain the requirement and logic?

Regards

Arun Sasi

[abhishekbiwal]

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