Execute Qlik Code stored in Excel

[rneelakantam]

Hi All,

I have my Qlik code store in Excel. Now i want to load from excel and execute the code in Qlik.

Note : I cant store the code in txt or qvs file and use include script

Thanks in Advance

[#2]

Hi All,

I have my Qlik code store in Excel. Now i want to load from excel and execute the code in Qlik.

Note : I cant store the code in txt or qvs file and use include script

Thanks in Advance

[rwunderlich]

When you say "code", do you mean load script?

-Rob

[LReeve]

Assuming you are storing your load script in a single cell then you should be able to do this:

LOAD
"Script"
FROM [lib://Downloads/DataLoad.xlsx]
(ooxml, embedded labels, table is Sheet1);

Let vScript = Peek('Script');

$(vScript);

Drop Table Sheet1;

If each line of the script is in a new Excel row you should be able to do something like (untested):

LOAD
Concat("Script"&chr(10))
FROM [lib://Downloads/DataLoad.xlsx]
(ooxml, embedded labels, table is Sheet1);