Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could load the excel and then pick from this load your needed fieldvalue respectively concat and/or aggregate multiple columns/rows and assign it to one or several variables and use them to perform your real loadings. It's quite the same like the content of the include-variables - and it must contain valid code.
Depending on the complexity of the code and the way how the code is stored in columns/rows it might not very easy to implement such logic. Therefore what is the reason for not using a Qlik application and/or include-variables?
- Marcus
HI Marcus,
Client is not ready to move the code from Excel to txt such that i can use Include script to load it directly.
Also Client wants to change the scripts frequently which would meet their requirements without moving the applications to PROD.