load from txt file other than writing it in qvw(edit script)

[#1]

is it possible to load from txt file other than writing it in qvw(edit script).

txt file contains

===========

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=tme;Data Source=OLISTADB_INT;Extended Properties=""] (XPassword is MJFSJaVNFDIA);

SUMMARY:
SQL SELECT a.* FROM summary_pcs a;

//store Qlikview Table from memory to disk

store SUMMARY into E:\qlikview\SUMMARY.qvd (qvd);

LOAD
timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID,CONTENT_PROVIDER_ID,ACCOUNT_TYPE,CONTENT_NAME,
YEAR(timestamp(EVENT_DATE,'DD/MM/YY')) as YEAR,PICK(month(timestamp(EVENT_DATE,'DD/MM/YY')),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')AS MONTH,DAY(timestamp(EVENT_DATE,'DD/MM/YY')) AS Day,
sum(AOC_SHOWED) , sum(AOC_REJECTED), sum(AOC_OK),sum(PURCHASE_FAILURE),SUM(PURCHASE_REVENUE),SUM(RENEWAL_REVENUE),SUM(PREMIUM_COUNT),SUM(CANCEL_COUNT),SUM(PURCHASE_COUNT),SUM(RENEWAL_COUNT)
FROM SUMMARY.QVD (QVD)
group by timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID,CONTENT_PROVIDER_ID,ACCOUNT_TYPE,CONTENT_NAME;


PROVIDER:
join LOAD CONTENT_PROVIDER_ID,PROVIDER_DESC;
SQL SELECT PROVIDER_ID CONTENT_PROVIDER_ID, PROVIDER_DESC FROM TME_PROVIDER;

[#2]

Yes.

By writing a code in edit script

$(Include=d:\script\create\test.txt)

[#3]

hi santosh how r u?

can u help me one thing.

i want to call the test1.txt from sheet1 and test2.txt from sheet2 .

can u help me out.

please elaborate on that

[#4]

I think this is not possible! you can only load data from the script panel.

You can do a reload from a sheet, but this is reloading from script

[mountaindude]

Santosh is right, if you in your reload script write

$(include=e:\script\temp\test.txt);

all lines in the test.txt file will be inserted in the reload script, just as if they had been typed there to begin with.

From the help file:

$(Include =filename )

The include variable specifies a file that contains text that should be included in the script. The entire script can thus be put in a file. A user-defined variable.

Example:

$(Include=abc.txt);

I.e. the construction set Include =filename is not applicable.

Best,

Göran