topic Re: can I embedded my script ? in QlikView

can I embedded my script ?

paulyeo11 — Fri, 09 Aug 2013 02:49:58 GMT

Hi All

I have many long script which is identical to different country . Only some of the line of script are diff. For example SOURCE , LINK_KEY which are diff.

In order to have less error . Does QV allow to comply those common script comply into a libary. So I can keep use them . And this will make my script less messy and neat.

Re: can I embedded my script ?

sushil353 — Fri, 09 Aug 2013 03:29:18 GMT

you can save your scripts in external files and then you can include those files using # include statement..

check the reference manual for using Include statement..

After that try to create some generalized variables which you can embedd in your script..

make changes in your variable for each import...

HTH

Sushil

Re: can I embedded my script ?

paulyeo11 — Fri, 09 Aug 2013 04:22:41 GMT

Hi Sir

It is possible you help me by give me a very simple exsmple ?

Re: can I embedded my script ?

sushil353 — Fri, 09 Aug 2013 05:40:00 GMT

ok.. let me try to replicate your senario

Re: can I embedded my script ?

sushil353 — Fri, 09 Aug 2013 05:54:40 GMT

I tried one sample application for you..

Hope you are looking for the same solution.

HTH

Sushil

Re: can I embedded my script ?

paulyeo11 — Fri, 09 Aug 2013 11:13:58 GMT

Hi Sushil

Thank for your example on include.

i study your approach , you make use of include text file to load the raw data . But my idea is try to make use of include for replace the follow script.

Pls take note that below 2 group of script , the only line diff is SOURCE_SALES and file name of data file at 3 row and last row of the script , my idea is how to make use of include for the rest of code. except the 2 diff key word.

sales_table:

LOAD left(FileBaseName(), 4) AS Report_dod_1,

'TDSPG' as SOURCE_SALES,

@1:10T as [cust_id],

@50:60T as [date],

@50:60T as [SALES_DATE],

if(@241:248T = '2',@134:147T*-1,@134:147T) as [sales],

left(@11:42T,31) as [company],

@313:343T as [desc]

FROM Q_FCPG09.txt (ansi, fix, no labels, header is 0, record is line);

sales_table:

LOAD left(FileBaseName(), 4) AS Report_dod_1,

'TDSKL' as SOURCE_SALES,

@1:10T as [cust_id],

@50:60T as [date],

@50:60T as [SALES_DATE],

if(@241:248T = '2',@134:147T*-1,@134:147T) as [sales],

left(@11:42T,31) as [company],

@313:343T as [desc]

FROM Q_FCKL09.txt (ansi, fix, no labels, header is 0, record is line);