Use Dynamic Input to Only Use File Modified in the Last 24 Hours

[apmessner]

I'd like to use a dynamic input tool to only pull in data from an Excel file that was modified within the last 24 hours.

So, for example, if it is currently November 3 at noon, I would only want the dynamic input tool to pull data in from an Excel file that was modified between November 2 at noon and November 3 at noon.

Does anyone have any thoughts on how to accomplish this?

Thanks!

[DavidP]

Hi @apmessner 

That's not how the dynamic input tool works. It is used to dynamically specify (from your workflow) which file or sheet to load. It has no knowledge of when data was added.

The only way I can think of to do this is to take a copy of the excel file once a day and then load both the live file and the copy and compare them in an Alteryx workflow

[chuckleswk]

You can't necessarily do that with a macro, but you can do that by pulling in the file info and using a filter to pull out those files that have been modified in the last 24 hours. I have attached an example of a flow that I have used for similar such examples. If you are loading it to a database or to another file, you can compare records for a change and then only load those.

[chuckleswk]

I have updated this flow to create a key which is unique to the row. If you load this key to the new file / database you can use that to determine records that have either had a change or that are new to the file.