Inputting Data with the 'Input Data' Tool

Is there any way to configure the 'data input' tool so that it brings in the most recent file from a folder

Say for example in Folder A we have file20170919.xls for Tuesday and file20170920.xls for Wednesday ... I'd like to be able to configure tool to input the file20170919.xls on Tuesday and then on Wednesday, the file20170920.xls and so on for the other days except weekends ... Is this possible? Thanks!

Input

Accepted answers

NicoleJohnson

No, in this case you won't need the directory tool. The concatenated string will specify the filename (assuming they are always consistently named as such) and then you can feed that directly into the Dynamic Input tool. You'll set up your initial connection to a file in the Dynamic Input tool and then choose the option to replace the filename with the concatenated filename (containing the updated date as part of the file name) to replace the filename initially used in the Dynamic Input tool. Does that help?

Claje

Hi,

If you're looking to use the Formula approach recommended by Nicole, you'd probably want to use a Text Input to start your workflow off instead. I would actually recommend a slight tweak to use the text input tool to read in the first part of the file name.

I called it fileprefix for my example below:

[fileprefix]+DateTimeFormat(DateTimeToday(),"%Y%m%d")+".xls"

Here's a quick screenshot:

All comments

Claje

Hi,

I don't think that the regular Data Input tool will allow you to do this exactly.

However, a combination of the Directory tool and the Dynamic Input tool should let you do this.

Basically you can set up your directory tool to point to your folder location and search for file*.xls inside folder A.

This will include some information like the last time the file was saved, or the filename, and you can use a filter to identify which file should be loaded on a given day.

After that, you can use dynamic input and update the file path completely, to read in the newest file.

NicoleJohnson

If the file name will always be the same base name + today's date in format yyyymmdd, you can also use a formula like this to create the filename that then feeds into the dynamic input tool: ="file"+DateTimeFormat(DateTimeToday(),"%Y%m%d")+".xls"

Daniel_Ajao

Thanks Nicole ... the concatenated string that you provided goes into the Directory tool right?

Daniel_Ajao

Thanks Clajet ... would you be able to provide more specifics as to how use dynamic input and update the file path,

I used the concatenated expression provided by Nicole in the 'File Specification' field of the Directory tool but I am getting zero output ... Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703