Hi everyone, hope everyone doing good
I am creating a alteryx workflow with input as a SharePoint input file. Realized that we need to fetch only the latest file ( i.e the previous month file because in August, July files will be posted like wise). While reading from SharePoint we need to read only the lates file data.
So i got to know using batch macro would be the best way. Started creating it and i was struck at the action point in batch macro. I used the path option there in the action tab ( which had the whole path including the file name).
I used update via formula method and created a formula like contains ([#1], Datetimeformat(datetimetoday(), '%b')
// I did to check whether if it is fetching current month files or not.. Will change later with datetimeadd formula to fetch the previous month file.
I believe #1 is the control parameter meaning the entire path ex: Docs/compname/importantdocs/input/Aug_file.xlsx
But when I try to run with putting the previous month file in the SharePoint it is fetching records f I put current month file it is also fetching records.
If I paste two files in the SharePoint both previous year and current year.. Those two files are getting processed.
Can anyone please help me in resolving it or kindly let me know if I need to use someother formula or to change the parameter which I need to pass ( the full path or only the file name)
Thanks in advance.
