This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow that pulls an excel file from a folder for everyday in the prior month. The files have the same name so it pulls the entire folder not just one spreadsheet. The problem I have is the files that are sent to me are missing the days for holidays and weekends. So for example: The folder will say MSTARNAV20181201, MSTARNAV20181202, MSTARNAV20181203, MSTARNAV20181206. As you can see the dates for 04 & 05 are missing. I need Alteryx to recognize the date gap and replace the missing files with the last date that it found. Basically, I need stale data for the missing dates so the 04 & 05 data should be duplicates of 03 in this example.. I'm hoping there's a way to do that, thanks for any help you can give.
If I understand you correctly, you are asking Alteryx to COPY the file from MSTARNAV20181203 and create new files that are MSTARNAV20181204 and 05. If that is correct, then an approach might be to generate a .bat file with the contents of:
Upon completion of this .bat file creation, you'll RUN an EVENT to execute the "WeekendCopy.bat" file that you created.
To find the missing dates, one approach might be to use a DIRECTORY input tool to see if there is a filename gap and then write these lines into the "WeekendCopy.bat" file. Another approach might be to use a GENERATE ROWS tool to create the missing date entries and then create those .bat entries.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.