Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Please let us know if this component tPivotToColumnsDelimited is able to achieve this.
Here is online component reference: TalendHelpCenter:tPivotToColumnsDelimited
Best regards
Sabrina
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