Update tOracleOutput field that matches a tOracleInput field value
Hello everybody,
How can I build a job that updates a tOracleOutput field, only when a tOracleOutput Id (Identification Field) field equals a tOracleInput Id field?.
Thanks a lot in advance,
Gracia.
Hi Can you be more accurate on which components performs what ? You may solve your problem by using tMap and/or tFilterRow.
Regards, Lie
Hello Lie,
Thanks for your answer :-). Using a tMap is OK. How can I define the condition over a tOracleInput field at the tOracleOutput?.
Thanks a lot again in advance :-),
Gracia.
Hi, You can use conditions as shown in my example below. Is this what you were looking for ?
Regards, Lie
Hello Lie,
yes, but with the tOracleOutput field "number". I mean, how willl you type the condition "row1.number = number" at the tMap?.
Regards, and thanks a lot,
Gracia.
Hmm...
I suppose you have a global flow of data and you want to filter datas which id equals to one in your input flow, then update datas in the database ? Am I right ?
If that's the case, use a tJoin, map your global flow id with your input flow id. The result should be only lines which has id in your input flow. The tOracleOutput should perform only on those lines.
It should be as easy as in my example below if I understood your problem.
Hmm... I suppose you have a global flow of data and you want to filter datas which id equals to one in your input flow, then update datas in the database ? Am I right ? If that's the case, use a tJoin, map your global flow id with your input flow id. The result should be only lines which has id in your input flow. The tOracleOutput should perform only on those lines. It should be as easy as in my example below if I understood your problem.
Hello Lie,
yes, you're right 🙂 , that's what I need. I'm going to try this solution.
Thanks a lot for your great help! ,
Gracia.
