How to input files based on keywords in the name of the file

[Mamamia]

Hi,

I was wondering if it is possible with Alteryx, to input files from a SharePoint folder, based on key words in the name of the file.

For Ex: We could have a spreadsheet saved as "Q1-24 Turnover Data". In three months, the Q1-24 file will be deleted from the folder and another will be saved as "Q2-24 Turnover Data", and so on....

Is it possible to just ask Alteryx to input the file that has the word "Turnover Data" in its name ?? Mindful there will only be one file in the folder called "Turnover Data" at any given time..

[cpet13]

Hi @Mamamia. This should be able to be done. In the regular Input Data tool, set up a connection and select a file. You can then select the file name and replace parts of it with a wildcard (eg. *Turnover Data*") to retrieve any file with that name. If you only want to retrieve specific file types with that file name, you could modify it to be *Turnover Data*.exe, or something similar to that. Here is an example of how I have done that in a workflow.  In this example, I have files that go into a folder every month with the date attached to the end. I used the wildcard to have the workflow retrieve the file with that specific name, regardless of the date at the end of the file - that way it would retrieve a file, even if the date on the end was changed.