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.

Output File Name - Empty with no data.PNG

Output File Name - Works good with data.PNG

binu_acs

@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

Empty_File_10092024.yxzp