File from directoy

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.

Common Use Cases

Accepted answers

MarqueeCrew

@bvolles,

The DIRECTORY tool is going to read a list of all files that begin with "me3050101_j223".
The INPUT tool is going to read your list of "PROCESSED" Files.
The JOIN tool is going to find the files that have not yet been processed and push them out the L anchor to a Dynamic Input tool.
The DYNAMIC INPUT tool is going to read a template and use a .CSV format (but use the ~ as the delimiter) to parse the data.
The UNION is going to update the file list and send the directory of "PROCESSED" Files downstream to ultimately overwrite the original File listings.

I hope that this helps.

Cheers,

Mark

File From Directory Help.yxzp

All comments

MarqueeCrew

@bvolles,

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

bvolles

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335