topic Re: Unknown Load Statement Error.... Stuck! in QlikView

Unknown Load Statement Error.... Stuck!

prees959 — Mon, 26 Nov 2018 12:37:18 GMT

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

Re: Unknown Load Statement Error.... Stuck!

Joan_MARTY_P3 — Mon, 26 Nov 2018 12:44:47 GMT

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

Re: Unknown Load Statement Error.... Stuck!

prees959 — Mon, 26 Nov 2018 12:52:13 GMT

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

Re: Unknown Load Statement Error.... Stuck!

Joan_MARTY_P3 — Mon, 26 Nov 2018 12:54:17 GMT

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.

Re: Unknown Load Statement Error.... Stuck!

sunny_talwar — Mon, 26 Nov 2018 12:59:19 GMT

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;

Re: Unknown Load Statement Error.... Stuck!

prees959 — Mon, 26 Nov 2018 13:05:52 GMT

Hi, that didnt work Im afraid

Re: Unknown Load Statement Error.... Stuck!

sunny_talwar — Mon, 26 Nov 2018 13:07:33 GMT

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

Re: Unknown Load Statement Error.... Stuck!

prees959 — Mon, 26 Nov 2018 13:14:15 GMT

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

Re: Unknown Load Statement Error.... Stuck!

sunny_talwar — Mon, 26 Nov 2018 13:21:40 GMT

Would it be possible to share the log file?

Re: Unknown Load Statement Error.... Stuck!

marcus_sommer — Mon, 26 Nov 2018 13:32:53 GMT

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

- Marcus

Re: Unknown Load Statement Error.... Stuck!

henkjankamphuis — Wed, 05 Dec 2018 15:14:15 GMT

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

Re: Unknown Load Statement Error.... Stuck!

Anonymous — Fri, 21 Dec 2018 09:20:33 GMT

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