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

[mageshwaran_subramanian]

How did you build the result table?

[abhishekbiwal]

hello Mangesh,

I need build the result table (table 4), using DS.

thanks and regards,

Abhishek Biwal

[mageshwaran_subramanian]

What is the logic behind the result table?

[abhishekbiwal]

Hello Mangesh,

The table will be mapped to Idoc segment.

Thanks and regards,

Abhishek