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 am trying to automate a solution that currently uses a excel macro to parse the data once I go and pick the file. What I want to do is have my workflow automatically grab the file each day. It sounds easy but here is the trick the file name changes everyday. Here is an example of the format: me305010_j60785_20170809.prn the underlined and bold part will always be the day before or on weekends it will be the past Friday. I appreciate any insight.
One approach that you can use is a DIRECTORY tool to read all of the .prn files that are in the directory. Upon successful completion of your job, you can write/update a file that contains all of the processed named files. The Directory tool can join on the filename to the processed file table and allow only NEW files to be read into a DYNAMIC Input tool.
Regardless of the name structure, this approach will read and process new files. You can also include date logic in the process if you should so choose.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Here is some sample data...I took out personal information. Also to note that these prn files are not in a folder on the network drive and there are several other prn files as well. The files I am interested in will always begin with me305010_j223