Dynamic input file - name changing

Dakotas

Hi all,

I have an input file that gets updated every week and the name changes to reflect that date, the name structure looks like this: "210127_Affiliation Data"

Is there a way to have Alteryx pick up that file even when the name changes or will I need to go in and re-link the input tool to the newest file? I was reading that it might be possible to have Alteryx pick up the latest file in a folder, but there could be other new files in the folder as well (with more static names) so I'm hoping there might be a way to do this based on the name structure.

Thanks!

-Dakota

echuong1

If this is the only file in the folder with that naming convention, you can simply have a wildcard in your input. Configure your input for one of the files, then go in and delete any part of it that will change and replace it with a *. The asterisk is a wildcard. For example, below will look for any file in the folder that has Affiliation Data at the end and is a csv.

Another option is to us a directory that will read in all of the file names from the folder. From there, you can use filters, sorting, and sampling to identify the file name that you'd like to import. This would then go into a dynamic input. You'll have to reconfigure the directory and dynamic input, but I've attached the general process.

Hope this helps!

New Workflow1.yxmd