Best INPUT solution for Monthly Operation

Question

Now, I have a lot of Monthly Routine Alteryx Flow.

However, I feel some difficulty for INPUT.

In Jan, I received 2018Jan_Source_Data.xlsx

In Feb, I received 2018Feb_Source_Data.xlsx

In Mar, I received 2018Mar_Source_Data.xlsx

Then, I open "Monthly_Operation_Flow.yxmd" and re-write File name at Input icon....

Unfortunately, every month file have slightly different format so I can't use dynamic input...

In this case, is there nice solution to change process automatic?

In sample, I keep 3 input file in Alteryx rawdata but actually, I don't need 3 file. I want to run flow with latest file only...

Thanks, Best regards.

Monthly Update.7z

BenMoss · Accepted Answer

Hi @Becky, here's how I would approach your problem. It uses a very basic batch macro that allows you to bring through the selected input file, even though the schema varies to what it may have been in the previous month.

Take a look at this and follow up with any questions you may have!

Ben