topic Re: Issue with Iterating through tFileInputExcel not iterating in Talend Studio

Issue with Iterating through tFileInputExcel not iterating

Tasfiahm — Wed, 15 Aug 2018 18:16:34 GMT

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.

Re: Issue with Iterating through tFileInputExcel not iterating

Anonymous — Thu, 16 Aug 2018 10:53:47 GMT

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

Re: Issue with Iterating through tFileInputExcel not iterating

Anonymous — Thu, 16 Aug 2018 11:03:28 GMT

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

Re: Issue with Iterating through tFileInputExcel not iterating

Tasfiahm — Thu, 16 Aug 2018 14:47:11 GMT

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