topic Re: Execute python script from qlikview load script in QlikView

Execute python script from qlikview load script

Prabhu — Sat, 16 Nov 2024 04:42:21 GMT

Hi ,

I am trying to execute below python script from qlikview load script:

EXECUTE C:\Users\14950\.spyder-py3\temp.py;

I have placed python script file and qvw in same folder. I also enabled "Can Execute external programs".

But, still no luck.

@sunny_talwar

Re: Execute python script from qlikview load script

pradosh_thakur — Tue, 22 Jan 2019 07:26:52 GMT

Hi Prabhakar

try out a few things to make sure this is not a qlik related issue first
1: Double click and run the file.
2: Run using command promt

check qlik related issue
1: Can execute external programs checked in script editor
2: Check the security tab in document properties and user setting if all the required setting are enabled for you
3: Execute "path_to_python.exe " " path_of_python_script_file";

Re: Execute python script from qlikview load script

Prabhu — Tue, 22 Jan 2019 10:29:53 GMT

yes, i followed this. The script execution is successful but, the data is not loaded from "temp.py" file.

Re: Execute python script from qlikview load script

pradosh_thakur — Tue, 22 Jan 2019 10:54:59 GMT

Not sure i understand . Can you check your script if it is doing what it is supposed to do ?

Re: Execute python script from qlikview load script

Prabhu — Tue, 22 Jan 2019 11:46:15 GMT

Below is the python script:
# Importing all required packages
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

#Importing dataset

media=pd.read_csv('mediacompany.csv')
print(media)

the script is supposed to load the data from mediacompany.csv file.

If i run the python script in spyder, it is fetching the data.

But, it is not fetching the data in QlikVIew.

Re: Execute python script from qlikview load script

pradosh_thakur — Tue, 22 Jan 2019 11:59:47 GMT

It will not load data in Qlikview and it will load data in any python.
Why not you are using the default loading in qlikview to load the data? It's just a csv file right, why you need python script here.