topic Re: Convert 1 column into multiple rows in Talend Studio

Convert 1 column into multiple rows

JAD2 — Fri, 15 Nov 2024 23:12:55 GMT

Hi Talend experts

Is possible to transpose one single column into multiple rows ?

So I have these values , all in the same column and I would like to be able to transpose them into 20 new rows so I can use the values later on in a Tmap

Re: Convert 1 column into multiple rows

Anonymous — Tue, 15 Feb 2022 15:08:57 GMT

You'll need to give an example of how you would like to do this. For example, row 1 in your example data holds ";1;2;". Do you want this to be turned into.....

null
"1"
"2"
null

.....or .....

";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"
";1;2;"

Or do you simply want to copy the whole of the dataset, but only this column of the data set?

Re: Convert 1 column into multiple rows

JAD2 — Tue, 15 Feb 2022 15:24:45 GMT

Pretty much as you said in the last part

";1;2;"
"A;B;C;D;E;F;G;H;Z;
";A;N;E;"
";A;B;C;D;0;"
"ETC"
"ETC"
"ETC"

To be fair , the only thing I really need is to store the values from the column individually

so I can use them later , so I thought that the easiest way to do it would be to store each value in a different row so I can use them as value1=;1;2 , value2=;A;B;C;D;E;F;G;H;Z , value3=;A;N;E etc later on in the tmap

Re: Convert 1 column into multiple rows

Anonymous — Tue, 15 Feb 2022 16:05:57 GMT

OK, these values can be stored individually if you wish. You can use the globalMap for this. How would you want to retrieve or use these values? With the globalMap you can use key/value pairs. So is there a "key" column that you will know the value of?

If so, you can use a tJavaFlex and store the values for each row using code similar to this....

globalMap.put(row1.columnKey, row1.columnValue);

To retrieve the values later, you will need to know the keys though. For example....

((String)globalMap.get("myknownkeyvalue"))

....for a String value.

Re: Convert 1 column into multiple rows

JAD2 — Tue, 15 Feb 2022 17:38:55 GMT

Thanks!!! It worked

Thank you very much 🙂

Re: Convert 1 column into multiple rows

Anonymous — Tue, 15 Feb 2022 17:51:14 GMT

Not a problem 😉