Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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/";
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/";