Convert Rows to Columns

[adnice]

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,

A

[Anonymous]

Hello,

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

Here is online component reference: TalendHelpCenter:tPivotToColumnsDelimited

Best regards

Sabrina

[adnice]

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.

A