Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Create a QVD

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

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

Did you define the table Debt100Z before your "Store into... (QVD)" statement?

Can you post the whole script?

View solution in original post

12 Replies
arulsettu
Master III
Master III

Hi

check the table name once

dinicholls
Creator II
Creator II
Author

HI Arul,

What do you mean, check the table name once?

Thanks

Di

anbu1984
Master III
Master III

Did you define the table Debt100Z before your "Store into... (QVD)" statement?

Can you post the whole script?

View solution in original post

senpradip007
Specialist III
Specialist III

Try like:

Debt100Z:

Load

*

From

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.

jagan
Luminary Alumni
Luminary Alumni

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.

arulsettu
Master III
Master III

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)



neetha_p
Master
Master

Hi,

Please check if table name is correct.

Regards

Neetha

Not applicable

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);

mato32188
Specialist
Specialist

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

ECG line chart is the most important visualization in your life.