Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying, in vain the create a QVD form a load statement. I've done it before with no problems, but don't seem to be able to do it now!
I have all my field name and what have you, and at the end of the script I have this:
FROM:
[H😕Qlikview\Target Setting\2014\December 14 Targets\Data Files\MI1411_100Z_ADT*.csv]FROM
(txt, utf8, embedded labels, delimiter is ',', msq, header is 8 lines);
STORE Debt100Z into H:\Qlikview\Target Setting\2014\December 14 Targets\Dec14_100Z_Debt_Target.qvd (QVD);
When I try and reload the script, I get the error:
SCRIPT ERROR:
Table not found
STORE Debt100Z into H:\Qlikview\Target Setting\2014\December 14 Targets\Dec14_100Z_Debt_Target.qvd (QVD)
What am I doing wrong? Do I need to create the table first? I can't remember if that's what I did last time, and if I did, I have no idea how I did it!
Thank you!
Di
Did you define the table Debt100Z before your "Store into... (QVD)" statement?
Can you post the whole script?
Hi
check the table name once
HI Arul,
What do you mean, check the table name once?
Thanks
Di
Did you define the table Debt100Z before your "Store into... (QVD)" statement?
Can you post the whole script?
Try like:
Debt100Z:
Load
*
From
(txt, utf8, embedded labels, delimiter is ',', msq, header is 8 lines);
STORE into Debt100Z into H:\Qlikview\Target Setting\2014\December 14 Targets\Dec14_100Z_Debt_Target.qvd (QVD);
Hope it will help.
Hi,
You need to specify the correct table name
TableName:
LOAD
*
FROM
[H😕Qlikview\Target Setting\2014\December 14 Targets\Data Files\MI1411_100Z_ADT*.csv]
(txt, utf8, embedded labels, delimiter is ',', msq, header is 8 lines);
STORE TableName into H:\Qlikview\Target Setting\2014\December 14 Targets\Dec14_100Z_Debt_Target.qvd (QVD);
In the above script replace TableName with your actual table name.
Hope this helps you.
Regards,
Jagan.
check both table name are same
example
Debt100Z:
a,
b,
c
FROM:
[H😕Qlikview\Target Setting\2014\December 14 Targets\Data Files\MI1411_100Z_ADT*.csv]FROM
(txt, utf8, embedded labels, delimiter is ',', msq, header is 8 lines);
STORE Debt100Z into H:\Qlikview\Target Setting\2014\December 14 Targets\Dec14_100Z_Debt_Target.qvd (QVD)
Hi,
Please check if table name is correct.
Regards
Neetha
Seems like you have not given your table a name (Debt100Z) . So when you are trying to store Debt100Z it cannot find it. Please see a simple example below.
MyTable:
LOAD * FROM xyz;
STORE MyTable INTO MyQVD.qvd (QVD);
Hi Diane,
is your FROM placed right?
FROM:
FROM
[H😕Qlikview\Target Setting\2014\December 14 Targets\Data Files\MI1411_100Z_ADT*.csv] FROM
(txt, utf8, embedded labels, delimiter is ',', msq, header is 8 lines);
M