topic Re: How to handle list iteration Correctly in Talend Studio

How to handle list iteration Correctly

kakooo16 — Thu, 07 May 2020 15:06:06 GMT

Hello Community , 
I have a problem while incremanting my list . 
However , i want to delete the items treated in my list : Here is my job design 

My tloop Configuration is as such  : 

 
My sql query is as such : 
I used the OFFSET to do a sort of pagination ! 

I m stocking the items in a list  Here . Then  im calling my list in this Query :
Then : I will call my Query here : 
 
So to recapitulate the issue is in this Screenshot : 
 

 
I want to not treat the items already treated  , means if my list storage is (1,2,3,.....,30 )
If i iterate the first 10 items -> i would treat the 10 second --> until the end of my List  . 
 
Im new to talend .
Thanks in advance . 

Re: How to handle list iteration Correctly

kakooo16 — Thu, 07 May 2020 20:47:28 GMT

Is there any response .

If there is any other detail that i can provide to make things clear im ready .

Still blocked !

Re: How to handle list iteration Correctly

kakooo16 — Fri, 08 May 2020 18:03:47 GMT

Is there any response or. Suggestion please ?

Re: How to handle list iteration Correctly

billimmer — Fri, 08 May 2020 20:38:42 GMT

your examples and screen shot are missing? I don't understand the problem.

Does the LIMIT / OFFSET work for you?

Re: How to handle list iteration Correctly

kakooo16 — Fri, 08 May 2020 20:43:30 GMT

Oh all screenshots are missing ! I don't know why !
The limit and offset is working fine Yes thanks to you !
But the issue when im trying to fill my list !
Im getting in the first iteration 10 items then in the second iteration 20 items the in the third iteration 30 items !
But my issue is i want to not treat the items already treated !