topic Re: Iterate tJavaRow Component in Talend Studio

Iterate tJavaRow Component

EThanumalayan1602246470 — Fri, 20 Nov 2020 19:17:15 GMT

Hi All,

I have a excel File which has below data

having a tJavaRow component to iterate through each row and perform a action by splitting each row into 2 rows. So the Desired output is

Help me to achieve the RowSplitting.

Note : Both Input and Output are of Excel file type

Re: Iterate tJavaRow Component

Prakhar1 — Sun, 22 Nov 2020 13:34:23 GMT

Hi,

I hv prepared a job with the same file input.

I have taken all the columns as string and also i have not used tjava row.

I have attached all the job SS in this message.

Please give a like and select as answer if it worked for you..

Re: Iterate tJavaRow Component

EThanumalayan1602246470 — Mon, 23 Nov 2020 11:05:09 GMT

Thanks @prakhar dubey, The above solution is going to split all the Rows from the input. If I need to split the rows by a condition Ex: (Num%2 ==0), the rows which satisfy the condition needs to be splitted. Is that possible ?

Re: Iterate tJavaRow Component

Prakhar1 — Tue, 24 Nov 2020 13:09:19 GMT

yes @Elango Thanumalayan you can use tfilterow and use your condition to send the rows to tMap

or you can also use the condition in tMap