How to access the table names from different component in tDBInput through SQL query in talend

556 Views Asked by At

enter image description here enter image description here enter image description here

I want to access the table names from tFileInputDelimited, so how to write SQL squery in tDBInput so that I can able to access the data of that table.please just see the image you can understand, there is SQL query which i have written.

I tried various ways but it's not working.

1

There are 1 best solutions below

0
On

try using this query

  "select  * from "+((String)globalMap.get("row2.Table_name"))+"" 

I supposed that your getting the right result from tFileInputDelimited to check that you have to link

tFileInputDelimited -> tLogRow