Help needed on executing Python script in Qlikview Loadscript

praveensprabhu — Sat, 16 Nov 2024 00:07:56 GMT

Hi Experts,

Need your valuable input on executing Python Command in QlikView Load script.

Can I pass parameters in Execute command of Qlikview like the way we do in Command prompt when we execute the python command.

Command Prompt Example :

python split_csv.py Z:\\graph\\export_poc.csv Z:\\graph\\ COST_CENTER

Can we do the same in Qlikview using "execute" command?

The funtion of the python script is to split the csv file "export_poc.csv" based on the column COST_CENTER present in the csv.

I know we can code the arguments inside the script. But instead of hard coding in the script, is it possible if we can pass the argument outside the python script and pass it from the load script.

Thanks,

Re: Help needed on executing Python script in Qlikview Loadscript

cwolf — Tue, 18 Aug 2020 09:41:40 GMT

Use full paths for python.exe and for the script. When specifying paths in parameters, use "/" instead of "\". Put all components in double quotes. For example:

EXECUTE "c:\Tools\WPy-3760\python-3.7.6.amd64\python.exe" "\\server3\QlikView\Scripts\SD_Backlog.py" -p "//server3/QlikView/Data/SD/";

topic Re: Help needed on executing Python script in Qlikview Loadscript in QlikView

Help needed on executing Python script in Qlikview Loadscript

Re: Help needed on executing Python script in Qlikview Loadscript