Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to aviod running file reduction script ?

Hi All

I want to reduce my QV data file size by create a sample QV Doc.

SET vDevelopment = 1; // 1 min 55 sec  local        QVD_PY      10% of Sample data.

above script will load all the sample raw data file. which can reduce the file size from 35 Mb to 14 Mb.

I want to further to reduce the total file size from 14Mb to 9 Mb , by below script :-

NEW:

NOCONCATENATE

LOAD *

RESIDENT sales_table WHERE BRAND_='HMS';

DROP TABLES sales_table;

Now my question is how to make my program only run above script when run :-

SET vDevelopment = 1; // 1 min 55 sec  local        QVD_PY      10% of Sample data.

As i have other script:-

set vDevelopment = 2;

it will run full raw data file , and i want to avoid running :-

NEW:

NOCONCATENATE

LOAD *

RESIDENT sales_table WHERE BRAND_='HMS';

DROP TABLES sales_table;

Hope some one can advise me.

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: How to aviod running file reduction script ?

Hi,

Try like this using IF

IF vDevelopment = 1 THEN

NEW:

NOCONCATENATE

LOAD *

RESIDENT sales_table WHERE BRAND_='HMS';

DROP TABLES sales_table;

END IF;

Regards,

Jagan.

3 Replies
paulyeo11
Valued Contributor II

Re: How to aviod running file reduction script ?

Below is my sample QV Doc

MVP
MVP

Re: How to aviod running file reduction script ?

Hi,

Try like this using IF

IF vDevelopment = 1 THEN

NEW:

NOCONCATENATE

LOAD *

RESIDENT sales_table WHERE BRAND_='HMS';

DROP TABLES sales_table;

END IF;

Regards,

Jagan.

paulyeo11
Valued Contributor II

Re: How to aviod running file reduction script ?

Hi Jagan

Thank you vey much , it work fine.

Paul

Community Browser