Input Data - with Current vs Previous month

[suby]

All,

I have a shared directory where I have all daily files are stored , 

For the Dynamic read.

1) Firstly I need to pick two files ( say 1st of March and 1st of April File) and do a comparison.

2) Secondly i want the flow to be dynamic say when i am in May i want to pick  (1st of April File and 1st of May file) and do a comparison.

the first thing I'm trying to attempt is making the read to automatically to pick the files.

Also i  need to compare two data sets and make this dynamic so I need  the dates like current vs previous to build logic in my flow.

Sample Dir/Files

xxxx_xxx_xx-xx2021-02-28xxxxxx.xlsx
xxxx_xxx_xx-xx2021-03-01xxxxxx.xlsx
xxxx_xxx_xx-xx2021-03-02xxxxxx.xlsx
xxxx_xxx_xx-xx2021-04-01xxxxxx.xlsx
xxxx_xxx_xx-xx2021-04-02xxxxxx.xlsx

Many thanks

[shreyanshrathod]

Have a look at this thread!!

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-multiple-excel-with-all-column-di...

Regards,

Shreyansh Rathod

[suby]

Cheers Much appreciated 

In terms of your flow what exactly the flow outputs could you please explain a little bit of flow.

Many Thanks