Issue with Iterating through tFileInputExcel not iterating

Highlighted
Six Stars

Issue with Iterating through tFileInputExcel not iterating

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.

 


Accepted Solutions
Moderator

Re: Issue with Iterating through tFileInputExcel not iterating

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: Issue with Iterating through tFileInputExcel not iterating

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

Re: Issue with Iterating through tFileInputExcel not iterating

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

 

 

Six Stars

Re: Issue with Iterating through tFileInputExcel not iterating

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch