Concatenation fails

[#1]

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?

[biester]

Just a guess: the SUM() function in connection with the %Date_key but without any group by clause seems strange to me ...

Rgds,
Joachim

[#3]

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

[biester]

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

[#5]

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