Wildcard Path in File Input

[Cat3]

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

[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 · Accepted solution]

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.