topic How to split one row into multiples rows? in Talend Studio

How to split one row into multiples rows?

Anonymous — Sat, 16 Nov 2024 13:57:16 GMT

I have the following input:
Row1: Name1, FirstName1, Charge1, Charge2, Charge3, Charge4
Row2: Name2, FirstName2, Charge1, Charge2, Charge3
and I would like the following output:
Row1: Name1, FirstName1, Charge1
Row2: Name1, FirstName1, Charge2
Row3: Name1, FirstName1, Charge3
Row4: Name1, FirstName1, Charge4
Row5: Name2, FirstName2, Charge1
Row6: Name2, FirstName2, Charge2
Row7: Name2, FirstName2, Charge3
It looks like I would have to use the Tnormalize function, but I am not able to get the result expected.
Thanks for your help

Re: How to split one row into multiples rows?

Anonymous — Fri, 15 May 2009 07:33:30 GMT

Hello
Before you use the tNormalize, you need to concact the normalize columns with another symbol. Here is a simple scenario:
in.csv:

Name1,FirstName1,Charge1,Charge2,Charge3,Charge4
Name2,FirstName2,Charge1,Charge2,Charge3

tJavaRow_1:

output_row.name = input_row.name;
output_row.firstName = input_row.firstName;
output_row.conn = input_row.c1+"@"+input_row.c2+"@"+input_row.c3+"@"+input_row.c4;

Result:

tarting job forum6611 at 14:30 15/05/2009.
.-----+----------+-------.
|       tLogRow_1        |
|=----+----------+------=|
|name |firstName |conn   |
|=----+----------+------=|
|Name1|FirstName1|Charge1|
|Name1|FirstName1|Charge2|
|Name1|FirstName1|Charge3|
|Name1|FirstName1|Charge4|
|Name2|FirstName2|Charge1|
|Name2|FirstName2|Charge2|
|Name2|FirstName2|Charge3|
'-----+----------+-------'
Job forum6611 ended at 14:30 15/05/2009.

Best regards
shong

Re: How to split one row into multiples rows?

Anonymous — Fri, 15 May 2009 21:36:11 GMT

Thanks a lot! Exactly what I needed.

Re: How to split one row into multiples rows?

jebiya — Wed, 29 Jun 2011 01:54:44 GMT

This has helped me as well. Thanks shong

Re: How to split one row into multiples rows?

Anonymous — Tue, 20 Oct 2015 11:58:07 GMT

SOURCE:

ID
58

MEMNO
369&370

NAME
Rohit Sharma/Bhupender K

DATE
8 Dec 2014/16 Jan 2014

Target: should be
ID MAMNO,NAME,DATE
58,369,rohitsharma,8 DEC 2014
59,370,Bhupender K,16 Jan 2014

how can we achieve this by using talend,please any body help me

Re: How to split one row into multiples rows?

Anonymous — Tue, 20 Oct 2015 12:00:58 GMT

ID
58
MEMNO
369&370
NAME
Rohit Sharma/Bhupender K
DATE
8 Dec 2014/16 Jan 2014

Target: should be
ID MAMNO,NAME,DATE
58,369,rohitsharma,8 DEC 2014
59,370,Bhupender K,16 Jan 2014
how can we achieve using talend and mysql

Re: How to split one row into multiples rows?

Anonymous — Wed, 21 Oct 2015 09:50:04 GMT

Hi manjunath.m,
Please take a look at tExtractRegexFields or tExtractDelimitedFields components.
https://help.talend.com/search/all?query=tExtractRegexFields&content-lang=en
https://help.talend.com/search/all?query=tExtractDelimitedFields&content-lang=en
Best regards
Sabrina