Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combine selective file from various folders

Need to select a xlsb file (name starts like yyyymmdd_report) from different folders with path reading like D:\daily updates\product n\yyyy\mm mmm\ The product name can be any text of 100+ counts and dd mm mmm yyyy denotes date formats. Any thoughts?
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    A good start would be Get Data from a folder, as below

     

    Later you can filter Folder Path column like below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

2 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

     

    A good start would be Get Data from a folder, as below

     

    Later you can filter Folder Path column like below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    So, Power Query is generally not a file search tool. Can you provide a little more background on this? What I would suggest would be to get all of the files into a single folder and then use a Folder query. But tough to really say. I suppose it would be possible to write an M function to do some file searching and if it finds a file, import it but that's really probably not the best use of Power Query.