One Star

Excel import and Database Query

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.
1 REPLY
Moderator

Re: Excel import and Database Query

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.