You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » [resolved] Access the results of tOracleInput in another tOracleInput
Post a reply
Topic review (newest first)
- hammerwd
- 2009-08-13 09:41:22
Hi,
I solved it on my own.
I just didn't know that I can use the Var in the middle of tMap.
The way I did it wasn't working (see screenshot)
Thank you 
Bye, Chris
- shong
- 2009-08-13 09:22:05
Hello
Please decribe your problem more detailed, where/why do you say you I can't access globalMap.something or row1.something in tMap? a screenshot of tMap will be better.
Best regards
shong
- hammerwd
- 2009-08-13 09:07:35
Thank you Shong it works.
But I need a to have two values from tOracleInput_1 in my tMap1.
I want to have values from tOracleInput_1 AND tOracleInput_2 in my tfileOutputExcel_1.
Unfortunately I can't access globalMap.something or row1.something in tMap 
What should I do now?
Bye, Chris
- shong
- 2009-08-13 05:29:21
Hello Chris
You can use the tFlowToIterate component, eg:
tOracleInput_!--row1-->tFlowToIterate-->tOracleInput_2-->do other transcation
On tOracleInput_2, type in the query like this:
"select srctable, desttable, detid from refs
WHERE srcid ="+(Integer)globalMap.get("row1.id")
Best regards
shong
- hammerwd
- 2009-08-12 14:33:50
Hi,
first I do a select on one table:
select id, edition, relasedate from print;
Next there is a reference table to query BUT with the results from the first query:
select srctable, desttable, detid from refs
WHERE srcid = FIRST_STATEMENT.id;
And I've got another two or three tables to query.
So, it's a join - but I need the results of the previous query for the where clause.
How can I do it in talend?
Thank you in advance.
Bye, Chris