topic Re: Convert Rows to Columns in Talend Studio

Convert Rows to Columns

adnice — Sat, 16 Nov 2024 00:30:20 GMT

Hello Experts,

Can you please guide me on the solution?

Here is the source data:

EmpName : ABC

EmpCountry : UK

EmpAc : UK12

EmpActive : Yes

Comments : N/A

EmpName : DEF

EmpCountry : USA

EmpAc : USA12

EmpActive : N/A

Comments : N/A

Need to convert to :

EmpName EmpCountry EmpAc EmpActive Comments

ABC UK UK12 Yes N/A

DEF USA USA12 N/A N/A

Thanks,

Re: Convert Rows to Columns

Anonymous — Tue, 02 Mar 2021 08:46:35 GMT

Hello,

Please let us know if this component tPivotToColumnsDelimited is able to achieve this.

Here is online component reference: TalendHelpCenter:tPivotToColumnsDelimited

Best regards

Sabrina

Re: Convert Rows to Columns

adnice — Tue, 02 Mar 2021 11:13:15 GMT

Hi @Xiaodi Shi

I tried with this component tPivotToColumnsDelimited but it is not giving me the desired result. I tried setting up a different combination of properties but nothing worked out. Can you please shed some light on what properties should be used.

below is an example. the new column is the first column of the file and newcolumn1 is the second column of the file after a delimiter :

Thanks.