Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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
MVP
MVP

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
MVP
MVP

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
MVP
MVP

Would it be possible to share the log file?
marcus_sommer
MVP
MVP

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

- Marcus