Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Just a guess: the SUM() function in connection with the %Date_key but without any group by clause seems strange to me ...
Rgds,
Joachim
The SUM() function works fine. if i create a table with OrderStand_Nieuw as label, it shows the new table correcly.
So, i don't know what's wrong with this
Rgds,
Rey-man
Very strange that it works as usually aggregate functions in the script (and generally also in SQL) don't work without a group by clause if used together with not aggregated fields. Actually, if I try similar I get an error (if ErrorMode is not set to 0).
Rgds,
Joachim
I too wonder, how it works!. The QV tabel name change (or its case) doesnot matter anyway. I can't visualize such a table structure design.
--Arun