Hello all,
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.
Solved! Go to Solution.
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.
Cheers,
Mark
How would I actually read the prn file? The directory tool just returned all prn files.
PS I am a beginner so take it easy on me :)
Can you post a sample file for us?
I hope that this helps.
Cheers,
Mark
@MarqueeCrew either I am being really dense or I missed something. what do I pull in the second input?
I was able to run it this time. Its not grabbing the most recent file however?