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

2 REPLIES
Nine Stars

Re: schema column name in front of each value.

Hi,

 

Are you looking for following output?

 

columnToRows.PNG

Regards,

Veeru Boppudi
Four Stars

Re: schema column name in front of each value.

yes!!

How did you set tmap?

 

p.s Sorry for the delay in getting back to you.