topic Re: Split the data in Talend Studio

Split the data

mani1304 — Sat, 16 Nov 2024 01:29:10 GMT

Hi there,

I have a requirement that if a semilcolon comes in a record, it should break into number of records but those fields are in the middle. e.g. if record is 100|a-- good to go, but if record is 100|a;,b;c;d then it should break into 4 records as 100|a,100|b,100|c,100|d

Please suggest.

Re: Split the data

Anonymous — Mon, 14 Sep 2020 08:30:25 GMT

Have you tried tNormalize component? I think you can check if the data contains a semicolon and filter the data, use tNormalize to split the data if it contains a semicolon.

Regards

Shong

Re: Split the data

mani1304 — Wed, 07 Oct 2020 08:19:28 GMT

Thanks Shong, sorry for the delay response but for the time I got some work around for this but I forgot to mention that this has a lot of columns and the required column is in middle somewhere so I don't think tNormalize for this, Is there something else which can be done here.

Re: Split the data

Anonymous — Fri, 09 Oct 2020 03:23:28 GMT

@Manish Mishra, I don’t understand you emphasize that these required column is in the middle somewhere. It would be appreciated if you can share your workaround on the community.

Regards

Shong

Re: Split the data

madhukolli2003 — Fri, 09 Oct 2020 14:40:10 GMT

Hi @Manish Mishra ,

tNormalize can split the value into multiple rows irrespective of column position.

Only limitation is it can only apply on single column.

Please refer below example .

Thanks & Regards,

Madhu Kolli