How to handle empty file?

[mkanduri]

I've 'Directory' as input for xlsx files where Option5 (Output File Name as Field) value 'File Name Only' works fine when files have data but returns empty value if any of the files is empty. How to handle this? I want get File Name as Field value even if the input file is empty. Attached the screenshots.

[binu_acs · Accepted solution]

@mkanduri change to the  below settings in the input tool, you will see the file name if there is  no data as well, then use the dynamic rename tool to get the original column names

[mkanduri]

@binuacs it worked fine, but need to do a bit more to avoid column headers showing as data values. Thank you.