.xlsx import for specific dates

Good afternoon,

Hopefully someone has a crafty solution or alternative for my need. I would like to pull the latest available excel file (only available on business days) and a file for each available month end (last business day of each month). What's the best way to achieve this?

Example:

2020-08-11.xslx

2020-08-10.xlsx

2020-08-07.xlsx

....

2020-07-31.xlsx

...

2020-06-30.xlsx

Datasets

Developer

Custom Tools

Macros

Accepted answers

echuong1

Yes, you will have to build a batch macro to import the data rather than the dynamic input. The beginning process will look the same when selecting the file path of the most recent file, but the dynamic input will be replaced with the macro.

See this article for information on creating the batch macro:

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

All comments

echuong1

This can be achieved relatively easily using the dynamic input tool.

Essentially, you'd import a list of all files in the folder. From there, you can actually sort and filter for the most recent file. The dynamic input tool will then use the file path to load the proper file.

See this article for more information and an example:

https://community.alteryx.com/t5/Alteryx-Designer/How-to-dynamically-run-the-most-recent-file-in-a-file-folder/ta-p/24204

anovohatski1

@echuong1 Thank you for recommendation. I tried this method, but unfortunately it didn't work given that some files have a different number of columns and therefore get skipped. Is there something else that I need to do to get it to work?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703