Excel import and Database Query

[_AnonymousUser]

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.

[Anonymous]

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