Something is strange with command "GROUP BY". This is my test case. When i use group by in my query from QVD, i try to concat the fields UCCONO and UCDIVI for my primary key. Unfortunately UCCONO & UCDIVI are empty... But in my QVD, i have no row empty for these fields.. What is wrong ?
CASE 1 : (Without GROUP BY)
LOAD
UCCONO &'|'& UCDIVI &'|'& UCFACI &'|'& UCORNO as KEY_OOHEAD_OSBST FROM ../../020_QVD/OSBSTD.QVD (qvd) ;
**********************
The result is : 500|001|E01|0002
CASE 2 : With GROUP BY
LOAD
UCCONO &'|'& UCDIVI &'|'& UCFACI &'|'& UCORNO as KEY_OOHEAD_OSBS,
sum([UCIVQT]) as [UCIVQT : Qté livrée ]
FROM
../../020_QVD/OSBSTD.QVD (qvd) GROUP BY UCCONO,UCDIVI,UCFACI,UCCUNO,UCORNO,UCPONR,UCIVNO,UCORIG;
