Issue with Iterating through tFileInputExcel not iterating

[Tasfiahm]

Hi I am trying to use tfilelist with tFileInputExcel component. In tfilelist it is able to iterate 2 files but tFileInputExcel is only processing 1 file. I have attached the screenshot of the issue. 

Please help me if you can.

[Anonymous · Accepted solution]

Hello,

Are you not able to load all your data from *xlsx files into your target output? Are your *xlsx files with same schema structure?

Best regards

Sabrina

[Anonymous]

Hi,

     The most probable reason for the issue could be that the sheet list specified in your fileinputexcel. Could you please hard code each file name (instead of current file path) and execute to verify whether the data is getting extracted properly for both files?

     If it is working fine for above step, could you please share the advanced settings of both components?

Warm Regards,

Nikhil Thampi

[Tasfiahm]

Thanks!!! it was a schema issue at the input side. After fixing it it was solved.