topic Load script from external txt-file in QlikView

Load script from external txt-file

Fri, 21 May 2010 07:04:04 GMT

I want to put my script in a txt-file instead of storing it in the qvs-file so I can version handle it. I put the code

$(include = "subfolder/filename.txt");

in my qvs-file but when I reload no data gets loaded. What am I doing wrong?

Load script from external txt-file

Fri, 21 May 2010 07:09:46 GMT

Hi,

There should not be double quotes.

Your script should look like this


$(include = subfolder/filename.txt);

-Peterson

Load script from external txt-file

Fri, 21 May 2010 07:14:56 GMT

I tried this also. It doesn't work.

Can I put the whole script in the txt-file or does some part of it need to be in the qvs-file? Now my qvs-file only contains the include-code.

Load script from external txt-file

Fri, 21 May 2010 07:19:33 GMT

Hi,

Check this application.

i have only include statement in my script and i have all my codes in text file.

It works as expected for me.

Below is the script which i have in text file


Test:
Load Product,
subfield(Sales,',') as Sales_New,
Sales;
LOAD * INLINE [
 Product, Sales
 a, "235,235,235"
 b, "235,236,237"
 c, "222,222,222"
 d, "222,223,224"
];
Test1:
Load Product,
if(Peek(Product) = Product and peek(Sales_New) = Sales_New, Sales_New,Sales) as Sales_New1,
Len(if(Peek(Product) = Product and peek(Sales_New) = Sales_New, Sales_New,Sales)) as Length,
Sales,
Sales_New
Resident Test;
Drop Table Test;
Right Join(Test1)
Load Product,
Min(Length) as Length
Resident Test1 group by Product;

-Peterson