Four Stars

schema column name in front of each value.

hi, I don't know schema column name in front of each value. 

please help me

 

↓Current Data

pk | Position | Receiving |Cash| Product_num | Unit_Price | Quantity
1 warehouse1 warehouse1 Y CAP,ELECTROLYTIC, TANTALUM, 80000 20
2 warehouse2 warehouse2 N IC, AD CONVERTER 19000 15

 

 

↓ The Data I want to change

pk: 1

Position: warehouse1 

Receiving  : warehouse1 

Cash : Y

Product_num  :CAP,ELECTROLYTIC, TANTALUM

Unit_Price : 80000 

Quantity : 20

pk: 2

Position: warehouse2

Receiving  : warehouse2

Cash : N

Product_num  :IC, AD CONVERTER

Unit_Price : 19000 

Quantity : 15

 

 

 

P.S) I tried to use 'tLogRow'. but I don't know 'tLogRow' output to file

1 REPLY
Community Manager

Re: schema column name in front of each value.

Hi
Please read this article about how to convert columns to rows.
https://help.talend.com/reader/Vya20tI3CbK3zEk~JdFPew/10~qmh4_SETV~7_uCusAOw

Let me know if you still have any questions.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business