Execute python script from qlikview load script

[Prabhu]

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

[pradosh_thakur]

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

[Prabhu]

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

[pradosh_thakur]

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

[Prabhu]

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.

[pradosh_thakur]

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.