Getting the file name when extracting the data

[Ankit_smart]

I am trying to add a column of the file name along with the data. I used the string manipulation tool to get the file name.

Then in the Loop end I selected add iteration column

Then I went in the flow variable and selected the additerationcolumn as file name

But it giving me an error at the end

Though solved it in the end using one more string manipulation and appending the file name in the as a new column but just curious to see what I am doing wrong

Name of the file is XXXX_DISCOVERY_MONTHLY_20190630

Also, I am able to extract data from few folder’s but when I am looping to about 100 files it’s giving me this error at excel reader. Is this a bug which is still pending to be fixed?

Execute failed: java.util.concurrent.ExecutionException: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Your InputStream was neither an OLE2 stream, nor an OOXML stream

[piotr_domagala]

Propably one od Excel’s files is in old 95/97 format. I have such error with this kind od Excel file.
Piotr

[Ankit_smart]

I used the Node Monitor to Find which file was giving me the problem. Turns out there was a hidden Desktop.ini file in the folder. Now to solve this I would put *.xls format in the List file menu. Thanks for the help guys.