Unknown Load Statement Error.... Stuck!

[prees959]

Hi,

I'm trying to use the following script :

Table:
LOAD
ID ,
NUM,
Money(Sum(TOTAL_PAID)) AS Total

FROM
..\..\Data\Payment_Details.QVD(qvd)

Group by
ID,
NUM;

But I'm getting an 'Unknown LOAD statment error'  and can't see what could be causing the error... can anyone spot anything?

Thanks,

Phil

[henkjankamphuis]

Hello @prees959 ,

Which version of QlikView Desktop are you using?
Does the script run when placing the QVW and QVD in the same folder? ( note: remove the ..\..\Data\  when you try this)
Have you tried running this script isolated from other script?

Kind Regards,
Henk Jan Kamphuis

[Anonymous]

Hi Phil,

In your Table LOAD statement there is space between ID and comma-sign which is likely causing the issue. 

Table:
LOAD 
ID ,
........

Best regards,

Micheal