Talend community forum / [resolved] Access the results of tOracleInput in another tOracleInput

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

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-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

Uploaded Images

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: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

Announcement

Unanswered posts

#1 2009-08-12 14:33:50

[resolved] Access the results of tOracleInput in another tOracleInput

#2 2009-08-13 05:29:21

Re: [resolved] Access the results of tOracleInput in another tOracleInput

#3 2009-08-13 09:07:35

Re: [resolved] Access the results of tOracleInput in another tOracleInput

#4 2009-08-13 09:22:05

Re: [resolved] Access the results of tOracleInput in another tOracleInput

#5 2009-08-13 09:41:22

Re: [resolved] Access the results of tOracleInput in another tOracleInput

Board footer