Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
prees959
Creator II
Creator II

Unknown Load Statement Error.... Stuck!

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

11 Replies
Joan_MARTY_P3
Contributor III
Contributor III

Hum one question first, are you using a lib or are you working in legacy mode ?

prees959
Creator II
Creator II
Author

I have no idea... one thing is we have recently upgraded to qv12 from qv11

Joan_MARTY_P3
Contributor III
Contributor III

Ah did not saw that you were running issue on QlikView 😞 unfortunatly, my knowledge is much much much less than on sense... I fear, I will not be able to support you on a good way.

sunny_talwar

Can you give a space between your file name and (qvd) and see if that works

Table:
LOAD ID ,
NUM,
Money(Sum(TOTAL_PAID)) AS Total
FROM ..\..\Data\Payment_Details.QVD (qvd)
Group by ID, NUM;
prees959
Creator II
Creator II
Author

Hi,  that didnt work Im afraid

sunny_talwar

Do you have any other script after this code? Also, Would you be able to share your log file?
prees959
Creator II
Creator II
Author

I have an 'exit script' directly after this .... 

sunny_talwar

Would it be possible to share the log file?
marcus_sommer

Maybe it's something like this: Exit-Script-not-working

- Marcus