12 Replies Latest reply: Jan 11, 2017 12:10 PM by Anna fuksa RSS

    Combining Tables

    Emanuel Zeilinger

      Hey,

       

      I have a problem with combining two tables which I have as QVD-Files.

      For better understanding I create these two tables:

       

      Table1:

      LOAD * INLINE [

          Auftr,      KdNr

          1,           aa,

          2,           cc,

          3,           ee,

      ];

       

      Table2:

      LOAD * INLINE [

          Auftr,      LSNr,      Date

          1,           xx,           10,

          1,           zz,           12,

          3,           yy,           11,

      ];

       

       

      What I want to have is a new table with the following content:

       

      AuftrNr,KdNr,LsNr,Date
      1,aa,--,--,
      1,aa,xx,10,
      1,aa,zz,12,
      2,cc,--,--,
      3,ee,--,--,
      3,ee,yy,11,

       

       

      I tried many different join as well as concatenate approaches but never got the correct result.

      Can someone help me?

       

      BR,

      Emanuel