Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Champs
A very unusual behaviour has got me mad over Qlikview.
I am trying to do a simple load * from a qvd file (10 GB) that was generated from an OLEDB connection and it gives me the 'General script error - Execution Failed'.
When I try to extract data from that QVD through qlik interface (Table files) it gives 'Unknown error' (attached screenshot).
I have tried deleting the QVD file and generate it, but still same error.
Folks any idea what I am doing wrong here. Any help is appreciated.
Thanks
Chakshu
In this can you use quotes around the variable. like
//----------------------Code------------------//
Max_Line:
Load max(ID_NUM) as Max_LineID
FROM
[QVD.qvd]
(qvd);
Let vMaxLineID=peek('Max_LineID',0,'Max_Line');
xyz:
Load * from
[QVD.qvd](qvd);
Concatenate(xyz)
SQL
Select * from [Dummy Source]
where ID_NUM > '$(vMaxLineID)';
Store xyz into QVD.qvd(qvd);
//----------------Finish------------------//
My code works. I've tested it.
That response was for Chakshu Jain. Just wanted him to try.