topic Re: loop on a condition in Talend Studio

loop on a condition

Anonymous — Thu, 16 May 2019 18:55:55 GMT

Hi team,

I want to distribute the attribute "number" by 1 on the attributes "Supp" which have the biggest "rest" and which are grouped by code,
I use:
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;}

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
Iwant an output like this:
code|number|rest|supp
1 |2 |150 |5
1 |2 |125 |2
1 |2 |110 |1
2 |3 |145 |1
2 |3 |130 |4
2 |3 |50 |2
2 |3 |10 |4

Could anyone please give me a hint of how to do this?

Your help is very much appreciated.

thanks,

nadakh

Re: loop on a condition

Anonymous — Fri, 17 May 2019 16:38:34 GMT

Your example does not make this very clear. Why does .....

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

......turn into this....

1 |2 |150 |5
1 |2 |125 |2
1 |2 |110 |1
2 |3 |145 |1
2 |3 |130 |4
2 |3 |50 |2
2 |3 |10 |4

The first 3 columns are exactly the same, but there doesn't appear to be a a reason for the column 4 change??

Re: loop on a condition

Anonymous — Sat, 18 May 2019 03:29:46 GMT

Hi rhall_2_0,

then, I will explain 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 -> Supp = Supp + 1
for "rest" = 125 we assign a "Number"=1 -> Supp = Supp + 1
for "rest" = 110 there is no "number" to assign it -> Supp = Supp + 0
and I repeat the same procedure for each code. (for code "2" I have "number" = 3 to distribute it)

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

Re: loop on a condition

Anonymous — Sat, 18 May 2019 12:25:14 GMT

I'm still not sure about the logic, but what you describe should be possible using a tJavaFlex (as you've suggested). What is the issue you are getting?

Re: loop on a condition

Anonymous — Mon, 20 May 2019 14:43:31 GMT

So, the code is like a group

Then "Number" is the total to distribute to the group
When you have distributed all (by doing +1 on each item), you stop distributing

Is it how it works?

Re: loop on a condition

Anonymous — Mon, 20 May 2019 15:17:24 GMT

Hi dgm01,

Yes it works like that.

Re: loop on a condition

Anonymous — Tue, 21 May 2019 07:59:24 GMT

Then it's simple,
You have to use global variables.

Then what do you do, if After distributing +1 to each item of the group, you have something remaining?

For example, let's say, for group (code = 1), you have "Number"=10
After distributing the 3 items, you have a remaining of 7

Re: loop on a condition

Anonymous — Tue, 21 May 2019 11:00:23 GMT

Always, "Number" < number of items , it will be distrubuted all

Re: loop on a condition

Anonymous — Tue, 21 May 2019 11:02:56 GMT

Now busy, will send the solution to you when I find time during the day

Re: loop on a condition

Anonymous — Tue, 21 May 2019 11:06:04 GMT

Ok thank you 😊

Re: loop on a condition

Anonymous — Tue, 21 May 2019 14:46:13 GMT

Find attached the job

Here is the tJavaRow

String code = input_row.code;
int num = input_row.number;

output_row.code = input_row.code;
output_row.number = input_row.number;
output_row.rest = input_row.rest;
output_row.supp = input_row.supp;

if( code.contains(context.current_code) ){
	context.to_distribute -= 1 ;
	output_row.supp += ( 0 > context.to_distribute ? 0 : 1 );
} else {
	context.current_code = input_row.code;
	context.to_distribute = input_row.number - 1;
	output_row.supp += ( 0 > context.to_distribute ? 0 : 1 );
}

hope this will help

DEMO_INTEGRATION.zip

Re: loop on a condition

Anonymous — Wed, 22 May 2019 10:27:02 GMT

l have this error when I set the context.to_distribute

Re: loop on a condition

Anonymous — Wed, 22 May 2019 10:47:41 GMT

Please, import the job I send to you and first test it

Then try to see how you can replicate on your job

Re: loop on a condition

Anonymous — Wed, 22 May 2019 15:47:53 GMT

Thank you, It works well .

I have another problem.

for the same procedure , I have the calculation expression : "rest"= A/(B+1)

but each time I recalculate the rest that got a number as follows: "rest"= (A/(B+1 +1)) (adding 1 )

and I start again until the "number" is distributed all.

Re: loop on a condition

Anonymous — Wed, 22 May 2019 17:32:46 GMT

Sorry, don't understand

What's A and B ?
If you add screenshot, it might help

Re: loop on a condition

Anonymous — Wed, 22 May 2019 18:05:07 GMT

reste=Voix/(supp+1)

for exemple, for code1: "number" to distribute =2

1) for "rest" = 584 / (2+1)=194.66
for "rest" = 840 / (3+1) =210
for "rest" = 863 / (3+1) =215.75 we assign a "Number"=1 -> Supp = Supp+1 ( because 215,75 is the max)

2) for "rest" = 584 / (2+1)=194.66
for "rest" = 840 / (3+1) =210 we assign a "Number"=1 -> Supp = Supp+1 ( because 210 is the max)

for "rest" = 863 / (3+1+1) =172.6

result:

code|Supp

1 | 2

1 | 4 (3+1)

and we repete for each group of code the same procedure precedent

Re: loop on a condition

Anonymous — Sat, 25 May 2019 18:35:56 GMT

I try this code in tjavaRow but it doesn't works:

//Code généré selon les schémas d'entrée et de sortie
output_row.code = input_row.code;
output_row.number = input_row.number;
output_row.VOIX = input_row.VOIX;
output_row.supp = input_row.supp;
output_row.rest = input_row.rest;

String code = input_row.code;
int num = input_row.number;
double reste =Double.valueOf(input_row.VOIX/(input_row.supp+1+1));

if( code.contains(context.current_code) ) and (context.reste<input_row.rest) {
context.to_distribute -= 1 ;
output_row.supp += ( 0 > context.to_distribute ? 0 : 1 );

} else {
context.current_code = input_row.code;
context.to_distribute = input_row.number - 1;
context.reste= Double.valueOf(input_row.VOIX/(input_row.supp+1+1));
output_row.supp += ( 0 > context.to_distribute ? 0 : 1 );
}

please I need your help to resolve this