Hi,
Yes, you could pass an interpolation variable using a formula to obtain the filename dynamically. For instance, to read a file with a dynamic filename located at a remote location, you could do the following:
* Create the required data source based on your file type and select **HTTP client** as the data route while configuring the data source. To pass the file name dynamically, you can use the interpolation variable in the file path URL as follows:
` https://acme.com/files?&filename=@{fileparam}.zip`
* Here @fileparam is the interpolation variable which means that the string @{fileparam} will be replaced at runtime by the value of the variable. You can refer to the section [Paths and Other Values with Interpolation Variables](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables) of the Virtual DataPort Administration Guide for more information on interpolation variable in the file path.
* Now, you must pass a sample value to the field fileparam(interpolation variable) to create the base view.
* After creating a base view, you can pass the filenames dynamically in the where clause to query the base view. To calculate the JULIAN date, you could use the [DateTime](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/datetime_functions/datetime_functions#datetime-functions) and [Text](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/text_functions/text_functions#text-functions) functions such as GETDAYOFYEAR, GETYEAR, SUBSTR, CONCAT, etc in the where clause.
Hope this helps!
