Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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/";

View solution in original post