topic Re: Split String[] in multiple row using tjavarow in Talend Studio

Split String[] in multiple row using tjavarow

Nad_s — Mon, 14 Nov 2022 16:57:29 GMT

Hi,

I would like to split a String[] in a tjavarow without using tNormalize.

tfixed ---1Row---> tJavarow ------3rows--> tLogRow

For exemple intput_row =

String[] s = ['S','Z','P']

at the exit of the tJavarow I would like to have 3 lines:

Row1 = S

Row2 = Z

Row3 = P

Re: Split String[] in multiple row using tjavarow

Anonymous — Tue, 15 Nov 2022 03:57:47 GMT

Hello,

Please have a look at this related topic about:

https://community.talend.com/s/feed/0D55b00006f3mkvCAA

Feel free to let us know if the solution works for your use case.

Best regards

Sabrina

Re: Split String[] in multiple row using tjavarow

Nad_s — Tue, 15 Nov 2022 07:32:08 GMT

This solution use a tNormalize... in my case it is not the way I want it to work

Re: Split String[] in multiple row using tjavarow

Anonymous — Tue, 15 Nov 2022 07:55:27 GMT

tJavaRow process data line by line, and it can't output multiple rows. My idea is that convert the string array to a string (eg: s=S,Z,P) on tJavaRow, and store the string to a context variable or global variable, then you can use tNormalize to split the string to multiple rows in next subjob.