This content has been marked as final. Show 4 replies
i've got a table with a date and a number
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.
SUM(OpenOrderStand_TEMP) + SUM(OrderIntake) - SUM(OrderOutgoing) - SUM(OrderCancel) AS 'OpenOrderStand'
,'$(vDatum)' AS %Date_Key
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?