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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MOussama1677058714
Contributor
Contributor

Talend Job different tables issue

Hello,

I'm new to talend and i'm working on a project where i need to create a job that takes a database connection , retrieve the list of tables in the database and then for each table i have to create a tmap to do some processing on columns , my problem here is that when i use TDBtablelist the iteration happens together while i need to get each table ( each iteration ) single handed and use it for tdbinput to then connect it to tmap.

What i'm getting now is all the tables together not each table on its own.

i'm sorry if this sounds confusing i'm new and i'm trying to learn about it.

If anyone knows what to do to solve my problem

thank you

Labels (2)
1 Reply
Anonymous
Not applicable

Hello,

If we understand your requirement very well, you are able to list the name of the current tables in the source and then iterate and make a "select * from [global_variable]" with the dynamic schema.

The workflow would be:

tDBTableList-->tJava-->OnComponentOk-->tDBInput-->tMap-->OutPut

Here is a related topic:

https://community.talend.com/s/question/0D53p00007vCmNZCA0/whole-database-migration-mssqlmysql-using...

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina