2 Replies Latest reply: Sep 22, 2017 6:15 AM by Dermot mcgoldrick RSS

    Load data from files in an array.

    Dermot mcgoldrick

      I know its possible to load data from all files in a folder with a specific naming convention, ie *Data.qvd etc.  Is it possible to do something similar but use the file names from an array or table within QV?

       

      Say load all data from :

       

      C:/Data/Jan_Sales.xls

      C/Data/Feb_Sales.xls

      C/Data/Mar_Sales_Adj.xls

      Etc

       

      I'm pulling data from multiple files over google drive and sometimes the files get renamed so would be simplier to correct in one location rather than multiple?  I'm sure you could do it with variables as well, but this would be cleaner for me?

       

      Thanks in advance.