how do i create a file dialog for a qvd file?

[#1]

I am currently reading data from a series of remotely generated QVD files.   The QVD files are regenerated frequently with randomized file names.   As a stopgap, I am currently modifying the file name by hand in the LOAD statement of my script each time I want to rerun the script, but obviously, this is rather tedious.  I would like to instead use a File Dialog box to select the filename and then dynamically use that filename in my LOAD statement.   I can't find any discussion on how to do this.  Is it possible?

[Gysbert_Wassenaar]

If you can create an 'algorithm' to determine the correct file name then it's possible. If not then I'm not sure it is. You can try loading a table of the file names so the user can pick one and store the value in a variable. But I'm not sure you can use the variable again in the script. You may need to enable the legacy script mode for that. And you'll need this extension: GitHub - mhamano/Qlik-Sense-Reload-Button

[krishna_2644]

These two links gives some good understanding on excel file enumerations.

https://community.qlik.com/thread/54342

Load multiple excel files from Multiple excel sheetsinto QV

Hope that helps.

[#4]

Hi Santiago,

This would work well.  Assuming I can generate the CSV file, do you have any sample code on how to read it in the script and use it generate a series of load statements?

Cheers,

Lyon