I'm trying to simulate a transpose function in TOS 2.2.0 (perl).
Here is an example of my input lines and what I pretend to get on output:
Since I didn't find any component to do it directly, nether a topic in the forum talking about this issue, I tried three different approach, but all without success:
1- Using a tAggregateRow component, I can't manipulate correctly the rows to generate all final columns
2- Using a tSortRow+tPerl with a loop to read lines from stdin until rowId change and then print to stdout the final row with all columns, I can't get data from stdin
3- Using a tSortRow+tPerlFlex+tMap+tUniqRow, I have problems accessing the data in tPerlFlex fields (with $tPerlFlex_1)
The problem with the third approach seems to be a bug (maybe I'm wrong) using the fields from tPerlFlex_1 array because a get no data. If I say directly that $colA='5' and $colB='3' then I get the pretended result for the first output row, but if I say $colA=$tPerlFlex_1 and $colB=$tPerlFlex_1 both variables steels empty.
If someone could help me solving this issue with one of these 3 approaches or a new one, I will appreciate.
Thanks in advance.
but the output of tPivot is delimited file.
if i want to make to another mySql table,
i m new in talend, can you please help me out with the following input:
row1 row2 row3
row4 row5 row6
row7 row8 row9
and the desired output is:
row1 row4 row7
row2 row5 row8
row3 row6 row9
Helo. i'am newbe in talend with java
i have a mySql table like this :
init descrip value
A limit 9
A rate 0
B limit 8
B rate 0
and i want to make output like this:
init limit rate
A 9 0
B 8 0
i've try used tDenormalize and put :
column delimiter merge same value
but didn't work.
do you have any solution?