topic Re: [resolved] row to column transformation in Talend Studio

[resolved] row to column transformation

_AnonymousUser — Sat, 16 Nov 2024 12:47:12 GMT

Hi,
Can anyone help me to do this row to column transformation:
Input file:
Col_A Col_B Col_C
1 2 3
4 5 6
7 8 9

Output file:
Col_A Col_B Col_C
1 4 7
2 5 8
3 6 9

I have tried with lots of components but i am not able to do that.
Thanks for your help !.

Re: [resolved] row to column transformation

Anonymous — Mon, 25 Jul 2011 13:17:14 GMT

Hi
Here I show a demo job to achieve the request,
in.csv:
1;2;3
4;5;6
7;8;9
on tJavarow_1:

1;2;3
4;5;6
7;8;9

on tJavaRow_2:

globalMap.put("c1", input_row.line);

on tJavaRow_3:

globalMap.put("c1", input_row.line);

result:

Starting job forum16973 at 20:07 25/07/2011.
 connecting to socket on port 3400
 connected
.----.
|tLogRow_1|
|=--=|
|line|
|=--=|
|1   |
|2   |
|3   |
|4   |
|5   |
|6   |
|7   |
|8   |
|9   |
'----'
.--+--+--.
|tLogRow_2|
|=-+--+-=|
|c1|c2|c3|
|=-+--+-=|
|1 |2 |3 |
|4 |5 |6 |
|7 |8 |9 |
'--+--+--'
 disconnected
Job forum16973 ended at 20:07 25/07/2011.

Best regards
Shong

Re: [resolved] row to column transformation

_AnonymousUser — Tue, 26 Jul 2011 08:28:25 GMT

Thanks a lot for your demo Shong.
I will try to adapt it for my needs.
Bests regards.
andrelaurent

Re: [resolved] row to column transformation

_AnonymousUser — Tue, 26 Jul 2011 15:18:12 GMT

Hi shong,
I was able to create your demo job but it looks to have a little error on tJavaRow_3. I think the correct code is:

globalMap.put("c2", input_row.line);

But the result is not that I asked in my first post
I need this output file:
1;4;7
2;5;8
3;6;9
Since yesterday I am trying to adapt your job without success. Could you please help me.
Thanks a lot
andrelaurent

Re: [resolved] row to column transformation

Anonymous — Wed, 27 Jul 2011 09:32:58 GMT

Hi,
tPivotOutPutDelimited might help you.
Please refer the below link for more details.
https://community.talend.com/t5/Design-and-Development/using-date-ranges-in-join-condition-of-a-tmap/td-p/114391

Re: [resolved] row to column transformation

Anonymous — Thu, 28 Jul 2011 10:02:59 GMT

Hi,
Thanks for your answer AchyuthB. tPivotOutPutDelimited would help me but it process only one column.
I found the tTurnRow unofficial component and it do exactly that I want.
Best regards
andrelaurent

Re: [resolved] row to column transformation

Anonymous — Thu, 28 Jul 2011 12:58:41 GMT

Hi,
Thanks for your answer AchyuthB. tPivotOutPutDelimited would help me but it process only one column.
I found the tTurnRow unofficial component and it do exactly that I want.
Best regards
andrelaurent

Hi
Cool, I was wrong to your needs.;(
Best regards
Shong