topic Re: How to aviod running file reduction script ? in QlikView

How to aviod running file reduction script ?

paulyeo11 — Wed, 17 Feb 2016 00:34:06 GMT

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

paulyeo11 — Wed, 17 Feb 2016 00:35:34 GMT

Below is my sample QV Doc

jagan — Wed, 17 Feb 2016 00:51:11 GMT

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 — Wed, 17 Feb 2016 01:30:18 GMT

Hi Jagan

Thank you vey much , it work fine.

Paul