topic Re: Create a QVD in QlikView

Create a QVD

dinicholls — Wed, 10 Dec 2014 10:20:08 GMT

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!

Re: Create a QVD

arulsettu — Wed, 10 Dec 2014 10:22:51 GMT

check the table name once

Re: Create a QVD

dinicholls — Wed, 10 Dec 2014 10:24:13 GMT

HI Arul,

What do you mean, check the table name once?

Thanks

Re: Create a QVD

anbu1984 — Wed, 10 Dec 2014 10:24:41 GMT

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

Can you post the whole script?

Re: Create a QVD

senpradip007 — Wed, 10 Dec 2014 10:24:45 GMT

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.

Re: Create a QVD

jagan — Wed, 10 Dec 2014 10:24:54 GMT

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.

Re: Create a QVD

arulsettu — Wed, 10 Dec 2014 10:25:24 GMT

check both table name are same

example

Debt100Z:

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)

Re: Create a QVD

Anonymous — Wed, 10 Dec 2014 10:25:43 GMT

Hi,

Please check if table name is correct.

Regards

Neetha

Re: Create a QVD

Wed, 10 Dec 2014 10:26:00 GMT

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

Re: Create a QVD

mato32188 — Wed, 10 Dec 2014 10:28:34 GMT

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

Re: Create a QVD

dinicholls — Wed, 10 Dec 2014 10:29:24 GMT

Thank you all!!!!

I am a muppet and didn't declare the table name at the start! Doh!

I shall go the corner of the room and face the wrong way for a while!

Thank you!

Re: Create a QVD

ankit777 — Wed, 10 Dec 2014 10:32:56 GMT

Hi,

Are there multiple tables in your script? maybe the tables get concatenated. Use Noconcatenate before table name and drop other tables.

Noconcatenate

Debt100Z:

Load *

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

Re: Create a QVD

jagan — Thu, 11 Dec 2014 02:00:30 GMT

Hi,

Please close this thread if you got the answer by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.