4 Replies Latest reply: Oct 20, 2009 2:15 PM by arunpaduva RSS

    Concatenation fails

    rey-man

      Hi all,

      i've got a table with a date and a number

       


      ORDERSTAND_OUD:
      LOAD
      OpenOrderStand
      ,%Date_Key
      FROM [file.qvd] (qvd)
      ;


      I've loaded and calculated some values to a new number for a new date and I named the fields the same.

       


      ORDERSTAND_NIEUW:
      LOAD
      SUM(OpenOrderStand_TEMP) + SUM(OrderIntake) - SUM(OrderOutgoing) - SUM(OrderCancel) AS 'OpenOrderStand'
      ,'$(vDatum)' AS %Date_Key
      RESIDENT ORDERSTAND_TEMP;


      but the tables wont merge. Even if I use CONCATENATE LOAD afterwards it doesn't put the new value in the existing table.

       

      Can somebody help me?