Tech Blog # Talend - Transpose Rows into Columns

Updated: Mar 14

Being a data engineer, we generally get scenarios in which we have to transpose row values into column values.

This blog will explain how to transpose Rows into Columns using Talend components.

In the example used , the source and target is an xls with the following structure -



  1. Employee ID

  2. Employee Name

  3. Employee Salary

TARGET XLS (Columns) -

Employee ID Employee Name Employee Salary

Refer the pdf for detailed step wise explanation on how to achieve the same -

Happy Learning!

Nayan Sharma

Learning Sutras

#talend #bigdata #etl #rowtocolumn #learningsutras

  • Twitter

©2019 Learning Sutras by Mitali Badkul & Nayan Sharma

DISCLAIMER - Members are accountable for their own content.