Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Connect to Dynamic Named File

Hi all,   At this moment I am building a new report based on several csv-files. However, these excel files are named dynamically. All the files are automatically saved in two folders: Current Mon...
Need Help
  • PattemManohar's avatar
    PattemManohar
    6 years ago

    Anonymous Did you tried using the "Folder" option available under "Get Data" ribbon instead of accessing direct source file as source.

     

PattemManohar's avatar
PattemManohar
Community Champion
6 years ago

Anonymous Did you tried using the "Folder" option available under "Get Data" ribbon instead of accessing direct source file as source.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    PattemManohar thank a lot for your reply.

    The solution was indeed (as simple as) to connect to the folder instead to the individual files.

     

    Now I connected to the folder, and filtered the loaded files in the Query Editor so that only the files ending with "Customer_Data.csv", "Customer_Eur.csv", Supplier_Data.csv" or "Supplier_Eur.csv" are loaded.

     

    In order to have these files as seperate tables I have duplicated the query (8 times, 4x for current month and 4x for previous months) and filtered based on the added column "SourceName"