Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Importing current month exports

kevin-lindorfer
7 - Meteor

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!

 

 

2 REPLIES 2
LordNeilLord
15 - Aurora

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


Data Lover

kevin-lindorfer
7 - Meteor
Works like a charm. Thank you!
Labels