5 Replies Latest reply: Jul 28, 2016 3:57 AM by Robert Hutschenreuter RSS

    Left Join causes columns to vanish

    Robert Hutschenreuter

      Hi,

       

      I've got a problem I can't figure out,

      I have two tables I try to left join but two columns vanish.

      LEFT JOIN BKN_REF2:

      LOAD

          MONATS_DATUM

          , RBKn

          , oBK

      Resident tabRBK;

      DROP TABLE tabRBK;

       

      After that it looks like

      in tabRBK the values of 'RBKn' and 'oBK' match, some of the value pairs for 'oBK' and 'MONATS_DATUM' are in both tables but the columns 'RBKn' and 'oBK' vanish.

       

      Does anybody have an idea what I should try or look for?

       

      Regards,

      Hutsch

       

      Message was edited by: Robert Hutschenreuter Attached qvw Because of privacy reasons I can't attach the qvd files so I added some inline loads. No the Problem occurs between lines 50 and 68, too