Importing current month exports

[kevin-lindorfer]

Hello!

I have created a flow to find errors in assets in a monthly report. I'm wondering if there is a way within Alteryx to ONLY pull the most recent file saved to a folder, or some way that it knows to pull the most recent report.

The export has the name in the same folder:

01 2018 SAP Export.csv

02 2018 SAP Export.csv

03 2018 SAP Export.csv

and so on...

I want it so that if it's April and I'm running the March report, it knows to pull 03 2018 SAP Export.csv and not anything else in the folder. 

I've tried messing around with dynamic input, but haven't achieved any results. 

Thanks much!

[LordNeilLord · Accepted solution]

Hey @kevin-lindorfer

• You can use the directory tool to bring back all of the file details in folder (and subfolders)
• then sort by LastWriteTime or CreationTime descending
• Use the sample tool to return to first record in the list
• Use the dynamic input tool to import that file.

See if you can get that working, if not let me know and i'll ping you an example

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[kevin-lindorfer]

Works like a charm. Thank you!