Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
praveensprabhu
Contributor
Contributor

Help needed on executing Python script in Qlikview Loadscript

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, 

 

 

Labels (2)
1 Solution

Accepted Solutions
cwolf
Creator III
Creator III

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/";

View solution in original post

1 Reply
cwolf
Creator III
Creator III

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/";