Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sunbaj
Contributor III
Contributor III

Read multiple tables in sequence

I have multiple tables in a database which have the same structure. I would like to read the tables in series and do some transfomation and then load them into the target. If I put a Union the issue is that unless all the records are fetched it does not start processing also duplicates in union will get deleted. 
Also every week new set of tables are created. So I would like to design a process something like filelist where I can populate the list of tables and then iterate it one by one. How do I implement the same in Talend

Labels (2)
3 Replies
Anonymous
Not applicable

Hi,
Here is a component t<DB>TableList which read the table name from database one by one.
[font=Verdana, Helvetica, Arial, sans-serif]Best regards[/font]
[font=Verdana, Helvetica, Arial, sans-serif]Sabrina[/font]
sunbaj
Contributor III
Contributor III
Author

xdshi wrote:
Hi,
Here is a component t<DB>TableList which   read the table name from database one by one.
[font=Verdana, Helvetica, Arial, sans-serif] Best regards[/font]
[font=Verdana, Helvetica, Arial, sans-serif] Sabrina[/font]

Thanks for helping. It did resolve my problem.
Anonymous
Not applicable

Hi,
Could you please mark this topic as resolved?
Best regards
Sabrina