Iterate tJavaRow Component

[EThanumalayan1602246470]

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

[Prakhar1]

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..

[EThanumalayan1602246470]

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 ?

[Prakhar1]

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