Discussion :

[kh.bi]

Hi,
I have this example, for the code "1": I have 3 lists, each list gets a "rest" and a "Supp" and I have a "Number" to distribute on the lists that have the most highest "rest"
(for code "1": I have "number" = 2):
for "rest" = 150 we assign a "Number"=1 -> tot = Supp + 1
for "rest" = 125 we assign a "Number"=1 -> tot = Supp + 1
for "rest" = 110 there is no "number" to assign it -> tot = Supp + 0
and I repeat the same procedure for each code. (for code "2" I have "number" = 3 to distribute
input:
code|number|rest|supp
1 |2 |150 |4
1 |2 |125 |1
1 |2 |110 |1
2 |3 |145 |0
2 |3 |130 |3
2 |3 |50 |1
2 |3 |10 |4
output:
code|tot
1 |5
1 |2
1 |1
2 |1
2 |4
2 |2
2 |4
I use:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
tOracleInput-> tSortRow-> Tjavaflex-> tLogRow
I use tSortRow to sort the "rest" attributes,
tJavaFlex:
for (int i = 0; i <= row7.code; i ++)
{for (j = 0; j <= row7.number; j--)   
{row10.Supp = row7.Supp + 1;}

I hope that I explain my problem well, I do not find how to make this loop with talend

[Matthieu2000]

ajoute une colonne à ta requête ...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
SELECT code,number,rest, supp,
   CASE rest WHEN 150 THEN supp+1
   WHEN 125 THEN supp+1
   ELSE supp END as tot
 
   FROM ...;

[kh.bi]

Je veux utiliser un code dans tJavaRow pour resoudre ce probleme