Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Tasfiahm
Creator
Creator

How to iterate through multiple Tabs/sheets in Excel file in Talend

I have an excel file which has multiple tabs/sheets with different name with same schema.

I want to iterate all the excel sheet one by one. What will be the most efficient way to accomplish the 

requirement. 

Input:0683p000009MZst.jpg0683p000009MZg8.jpg

0683p000009MZnb.jpg

Labels (3)
1 Reply
manodwhb
Champion II
Champion II

@Tasfiahm , first you should maintain a table or a file to all have sheet name and read it and iterate using tflowtoiterate,and then pass to global variable of tflowtoiterate to tfileinputexcel.