Forum Discussion

dancarr22's avatar
dancarr22
Icon for Helper V rankHelper V
9 years ago
Solved

Connecting to Folder but filtering by file name

Hello,   We are conecting to a folder which has multiple files -- basically 3 different file formats.  Is there a way when we connect to the folder -- maybe going into 'Advanced' where it shows it ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    dancarr22,

    Add a custom column in Query Editor using the following formula, then filter the custom column to "Yes".

    if Text.Contains([Name], "Equity") then "Yes" else "No"

    You can review the example below.



    Regards,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

dancarr22,

Change the code in your Advance Editor to the following:

let
    Source = Folder.Files("YouPath\folder"),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xls"))
in
    #"Filtered Rows"

Then in Query Editor you are able to view only those files with .xls in Query Editor, there is an example for your reference.


Regards,

  • dancarr22's avatar
    dancarr22
    Icon for Helper V rankHelper V
    9 years ago

    Thanks!  This is great -- answer 90% of my question.

    One follow-up then will close this: how would I filter by file name instead of file extension -- i.e. All files that begin with or contain '%Equity%'.

     

    Thanks for your assistance with this -- greatly appreciated.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      dancarr22,

      Add a custom column in Query Editor using the following formula, then filter the custom column to "Yes".

      if Text.Contains([Name], "Equity") then "Yes" else "No"

      You can review the example below.



      Regards,