topic Re: tOracleOutput insert AND update in Talend Studio

tOracleOutput insert AND update

Anonymous — Sat, 16 Nov 2024 14:04:26 GMT

Hi,
I have a problem ...
I have an input file :
Desc :
code;mois;valmois1;valmois2;valmois3;
S1; 01; 11; ; ;
S2; 01; 21; ; ;
S3; 01; 31; ; ;
S4; 02; ; 42; ;
S5; 02; ; 52; ;
S3; 02; ; 32; ;
S6; 02; ; 62; ;
S7; 03; ; ; 73;
S5; 03; ; ; 53;
S3; 03; ; ; 33;
S8; 03; ; ; 83;
...
I want writting on DB (Oracle) :
Desc :
code;valmois1;valmois2;valmois3;
S1; 11; ; ;
S2; 21; ; ;
S3; 31; 32; 33;
S4; ; 42; ;
S5; ; 52; 53;
S6; ; 62; ;
S7; ; ; 73;
S8; ; ; 83;
...
with (?)
tFileInputDelimited --> ? --> tOracleOutput
I don't see how I can do that ...
Thank you for your help
Quartz

Re: tOracleOutput insert AND update

Anonymous — Tue, 17 Feb 2009 09:49:20 GMT

Hello,
u have some trouble, i have a respond
Replace "?" by a tAggregateRow : group by mois, use max ( or first ... ) function for valmois1, valmois2, valmois3

Re: tOracleOutput insert AND update

Anonymous — Tue, 17 Feb 2009 09:54:57 GMT

Hi,

use tAgregateRow with sum function (see capture) before insert on database

Jeremie

Re: tOracleOutput insert AND update

Anonymous — Tue, 17 Feb 2009 11:59:28 GMT

Thank you !!!!
You are very good
Quartz