Excel import and Database Query

_AnonymousUser — Thu, 17 Jan 2013 15:26:33 GMT

Hi,
I did the following:
tFileList -Iterate-> tFileInputExcel -row1-> tConvertType -row3-> tFlowToIterate -Iterate-> tOracleInput -row2-> tLogRow
Now i have a table with data from the database but what I need is a table data from the database and the excel file. Does anybody know how i can do this?
I don't want to do a simple tMap between the tFileInputExcel and the tOracleInput because the database table consits of thousands rows.

Re: Excel import and Database Query

Anonymous — Fri, 18 Jan 2013 06:47:29 GMT

Hi,

tFileList -Iterate-> tFileInputExcel -row1-> tConvertType -row3-> tFlowToIterate -Iterate-> tOracleInput -row2-> tLogRow
Now i have a table with data from the database but what I need is a table data from the database and the excel file. Does anybody know how i can do this?

If i don't make misunderstanding your requirement, do you want to use a dynamics sql in tOracleInput to get the query?
Put the following sql into your tOracleInput component

 "select * from tablename where name='"+(String)globalMap.get("row3.name")+"'"

Hope it is what you need.
Best regards
Sabrina

topic Re: Excel import and Database Query in Talend Studio

Excel import and Database Query

Re: Excel import and Database Query