Create a QVD

[dinicholls]

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

[dinicholls]

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!

Di

[ankit777]

Hi,

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

eg

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

[jagan]

Hi,

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

Regards,

Jagan.