topic Re: Row & column in Talend Studio

Row & column

lmit — Wed, 27 Jul 2022 12:34:10 GMT

Hi All,

My input file is like below

Name;Age;product

and my output should be

Name

Age

product

The inputfile has only one record

Can anyone help me with the solution , am using talend open studio 8.0

Thanks in Advance

Lmit

Re: Row & column

manodwhb — Wed, 27 Jul 2022 12:46:44 GMT

@none none , check the below link , you need to use custom component. which is tUnpivotRow.

https://help.talend.com/r/en-US/7.3/converting-cols-to-rows/converting-columns-to-rows

Re: Row & column

lmit — Wed, 27 Jul 2022 13:00:21 GMT

Thanks @Manohar B for the quick reply but i cant use custom component due to client limitations

Can you please suggest any other way to achieve this

thanks in advance

lmit

Re: Row & column

lmit — Thu, 28 Jul 2022 04:51:09 GMT

HI All,

any suggestions please apart from the component tUnpivotRow

@Manohar B , am not able to download the tUnpivotRow component , when am trying to download its asking for login and when i give the details its saying "permission deinied"

Thanks in advance,

Lmit

Re: Row & column

gjeremy1617088143 — Thu, 28 Jul 2022 09:01:28 GMT

hi @none none ,

https://community.talend.com/s/question/0D53p00008NeCUfCAN/how-to-make-a-regular-and-easy-transposition-pivot-row-to-columns

Send me love and kudos

Re: Row & column

lmit — Fri, 29 Jul 2022 05:49:43 GMT

Hi @guenneguez jeremy , thanks for your reply but the solution you provided is not giving me the correct results

My input will look like

Name;age;productID

Output should be

name

age

productID

The solution you shared is opposite to my requirement even then i tried with what you suggested but couldn't get the required result

Out the output as input itself

Thanks,

lmit

Re: Row & column

lmit — Fri, 29 Jul 2022 05:50:37 GMT

Hi All,

can someone help with other solutions

Thanks,

Lmit

Re: Row & column

lmit — Fri, 29 Jul 2022 05:53:05 GMT

Hi @Manohar B , can you tell me how to download the component because am getting error while login into the exchange page as "permission denied"

Is there any other way to download the component

Thanks,

Lmit

Re: Row & column

Anonymous — Fri, 29 Jul 2022 07:53:47 GMT

@lmit, I attach the component in this post, please refer to this article to learn how to install the component to studio.

BTW, please send mail to community_help@talend.com if you have log-in issue to Talend Exchange.

Regards

Shong

Re: Row & column

lmit — Thu, 04 Aug 2022 09:57:20 GMT

Hi @Shicong Hong , thanks for the component , and i was able to achieve what i needed.

Thanks to all

Thanks,

lmit