Read Data automatically in one folder

Question

Hi All,

Seeking your help to advise me which Tool I should use to read the certain data file in the folder directly & automatically. (if should use other tool, plz help to advise)

Instead of drag & drop the data from the folder each time, I would like to let workflow automatically read the data by date today and yesterday (exclude weekend)

Not sure how i should use Directory here or other tool i should use.

my workflow just need today & yesterday data (weekday)

Raj · Answer

To exclude weekends, you can add a "Filter" tool after the "Directory" tool and use a formula like IF DAYOFWEEK(DateTimeModified) <= 5 THEN [File Path] ELSE "" ENDIF

Yoshiro_Fujimori · Answer

@k3pineapple

You may also want to check these posts.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynamic-Dynamic-Input/td-p/329286

alexnajm · Answer

Possibly even better, if there are written out on those dates, you could read in the file using the same "SampleData1*.xlsx" file specification in the Directory tool, Sort on the CreationDate, and Sample to the First 2 records which would presumably be your two newest date files!