• Twitter

©2019 Learning Sutras by Mitali Badkul & Nayan Sharma

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 -


Scenario

SOURCE XLS (Rows) -


  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

529 views