We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Use directory tool to pull files based on creation date?

DaveSchloat
7 - Meteor

Hello, 

I would like to have the directory tool pull just the file data for the files created today (dynamically).  I know I can read the folder and pass through a filter, but the folder has a truly obscene number of files in it, so pulling all that data takes a very long time.  I could have the WF run in a fraction of the time if I could specify the creation date.

And no, I can't use file name because the file name does not contain the date.

 

Alternatively, I COULD look for files based on a dynamic list of a portion of the file name.... if there's a way to do that.  

 

But creation date would be best.

12 REPLIES 12
TimN
13 - Pulsar

I found this:

https://superuser.com/questions/326021/dos-batch-file-to-find-new-files-by-date

 

Xcopy and list the files.  It works and allows you to filter with a date but I can't see how to bring back the creation dates.  All that is returned is the Filename

TimN
13 - Pulsar

I'm testing now and it's taking a while.  I'd also be careful with the run command and DOS.  This seemed like a possible solution but maybe it's time to look at something else.

DaveSchloat
7 - Meteor

Yes.  I'm really hopeful that I get granted read access to a table that has all this stuff, AND a code I can filter off of.  But I think I have to put up my first born as collateral for that.  Eh, might be worth it.  LOL!  Have a great holiday, and thanks to everyone for their input!

 

Labels
Top Solution Authors