Forum Discussion
dancarr22
Helper V
Helper VConnecting 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 ...
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,
dancarr22Helper V
Helper VThanks! 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.
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,