Pop Up for loading locally-stored data and trigger an sql query

Dear all,

Here is what I am trying to achieve in Spotfire but I am not sure if/how I can really do it with IronPython

1- Create a button that opens a pop-up window and asks the user for the path to up-load a locally-stored csv file

2- Once the file is loading in the spotfire report, execute a basic sql query between these new data and a data table stored in the spotfire report. The idea is to give the user the possibility to load their own data and extract the corresponding data from the report.

3- Visualize only the data where a certain column is greater than a certain value.

Regards

(1) Answer

Login