Extract filename from a file with no data

Question

Hi,

I am currently extracting a dates from filenames, however i have come across an issue where i have an empty file and still need to input the filename of that file to extract the date.

I use the Output File Name as Field in the Input tool.

Is there another way for me extract the filename from a file that might not have any data?

BrandonB · Accepted Answer

Depending on your process, you could instead leverage the Directory tool which contains file and metadata information https://help.alteryx.com/current/designer/directory-tool

Qiu · Accepted Answer

@aka_ash 
Can you further define "empty"? I use directory tool and pull out the information of an "empty" excel file.

We can use Run Command tool if necessary.