pivot

[Anonymous]

 Transpose the columns to rows

 Input:     

Name	English	Tamil	maths
AA	60	80	90
BB	88	76	99
CC	85	90	88

Output

Name	Subject	Mark
AA	English	60
AA	Tamil	80
AA	maths	90
BB	English	88
BB	Tamil	76
BB	maths	99
CC	English	85
CC	Tamil	90
CC	maths	88

[manodwhb]

@saravanan_ehkn ,check the below example.

https://community.talend.com/t5/Migration-Configuration-and/Converting-columns-to-rows/ta-p/21658

[manodwhb · Accepted solution]

@saravanan_ehkn , you need to use custome component of tUnpivot from talend exchange and install and design the job below way.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

[Anonymous]

Thanks it's working

29_day.csv

[manodwhb]

@saravanan_ehkn ,please accept the solution and also provide kudos.