QVD store command error

[Anonymous]

Hi all,

I am trying to store a QVD by using store command. EVen though I am giving correct path, it is throwing error.

Here initially I am read one Qvd from the same path and renaming and saving the  QVD based on some condition.

Regards,

Kumar

[Colin-Albert]

The source table Incmonths is causing the error not the file path.

Does the Incmonths table have any data in it?

[aniketsr]

Hi Kumar,

Put the qvd path in the below format

Store Incmonths into [QVD PATH]

or

Store Incmonths into "QVD PATH"

[Colin-Albert]

Can you post more of your script?

Are you loading the source QVD twice - you may need to use "noconcatenate" or rename the fields.

[sasikanth]

HI,

Check the table name  'Incmonths' , this might be the issue

[jonathandienst]

Comment out the STORE line and open the table viewer after the reload. You will see that IncMonths was not created or was dropped before the STORE command.

If IncMonths had the same fields as another table, the load may have auto-concatenated into the other table, as mentioned by ca above.

[Anonymous]

Your syntax looks okay..

Just check whether Incmonths exist or not?

[Anonymous]

Hi All,

This is my script.

Let Vqvdpath = 'D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Retention\QVD Retention\';

Inserts:

LOAD * FROM

$(Vqvdpath)fact_site_visit.QVD (qvd);

MinMaxDates:

LOAD

     Max(Floor(Timestamp#(site_visit_updated_datetime, 'MM/DD/YYYY hh:mm:ss.fff'))) as MaxDate

Resident Inserts;

LET vMinMonth = num(AddMonths(Peek('MaxDate'),-13));

DROP TABLE MinMaxDates;

Incmonths:

LOAD *

Resident Inserts

WHERE site_visit_updated_datetime > '$(vMinMonth)';

STORE Incmonths into $(Vqvdpath)fact_site_visit_History.QVD (qvd);

DROP TABLE Incmonths;

[Anonymous]

My source QVD is having more than 200 million records.

[Colin-Albert]

You need to add a NOCONCATENATE as the field names are the same so QlikView will add he rows to the existing Inserts table not create a new table.

Try

Incmonths:

NOCONCATENATE

LOAD *

Resident Inserts

WHERE site_visit_updated_datetime > '$(vMinMonth)';

STORE Incmonths into $(Vqvdpath)fact_site_visit_History.QVD (qvd);

DROP TABLE Incmonths;