Wildcard Path in File Input

I am using "Input Data" for data input. The file path should be variable. I tried to make wildcard file path, it got "File not found" error. Can anyone please help?

My wildcard file path:

C:\web_log\*_2018\07\*access.log (Got "File not found" error)

Example of the file path:

C:\web_log\web_2018\07\01_access.log

C:\web_log\web_2018\07\02_access.log

C:\web_log\event_2018\07\01_access.log

C:\web_log\event_2018\07\02_access.log

Input

Accepted answers

cmcclellan

I would do this ....

In your Input Data, choose a single file and format the tool to the settings you want.

After that, change the file spec in the tool to : C:\web_log\*access.log

Enable "Search SubDirs"

Change "Output File Name as Field" to Full Path

All comments

seinchyiwoo

Hey,

Wildcard will only work for filename currently.

Have you tried retrieving all the path using Directory tool first then batch read them in using Dynamic Input?

Something that works like this:

1. Use Directory to retrieve all the paths:

2. Then use Dynamic Input to read a list of data sources:

Note that you will need to first point "Input Data Source Template" to one of your file to make it work.

Hope this helps.

Seinchyi

cmcclellan

I would do this ....

In your Input Data, choose a single file and format the tool to the settings you want.

After that, change the file spec in the tool to : C:\web_log\*access.log

Enable "Search SubDirs"

Change "Output File Name as Field" to Full Path

grazitti_sapna

Hi @Cat3 , try using two input tool with the following path
C:\web_log\web_2018\07\*_access.log

C:\web_log\event_2018\07\*_access.log

This might work for you as you cannot use wildcard for directory.

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703