Store into qvd

[#1]

I want to store each table that I use into a qvd.

When I reload the script I get the error that loading the script has failed.

It was running perfectly before I added the store expression.

Can anyone see what is wrong with my script?

Kind regards,

Katleen

[MayilVahanan]

Hi

Do you have QVD folder and that path location which you are mentioned is validate?

[aveeeeeee7en]

Don't use Brackets [ ]

Use this:

Store projects into ..\QVD\projects.qvd(qvd);

Drop Table projects;

Regards

Aviral Nag

[amit_saini]

Try This:

projects:

LOAD id                                                                     as project_id,

    `continent_id`,

    `country_id`,

    `branch_id`,

    `region_id`,

    `agency_id`,

    name                                                                     as project_name,

    description,

    active                                                                     as project_active,

    status                                                                     as project_status,

    account,

    type,

    `is_deleted`                                                            as project_is_deleted;

SQL SELECT *

FROM `ciweb_denc_qlikview`.projects WHERE is_deleted="0";

Store projects into ..\QVD\projects.qvd(qvd);

Drop Table projects;

Thanks,
AS

[#5]

This is the qvw that I use and the folder where I want to store my qvd.

[#6]

Still doesn't work.

I tried it without the brackets.

[senpradip007 · Accepted solution]

I think first you should  try with absolute path then with relative one.

[MayilVahanan]

HI

Try like this

Store projects into projects.qvd(qvd);

If its stored, then problem in the location which you trying to save.