Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.