Pop Up for loading locally-stored data and trigger an sql query
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.