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 -


CLICK HERE FOR ROW TO COLUMN TRANSPOSE - TALEND - PDF

Happy Learning!

Nayan Sharma

Learning Sutras


#talend #bigdata #etl #rowtocolumn #learningsutras

743 views
  • Twitter

©2019 Learning Sutras by Mitali Badkul & Nayan Sharma

DISCLAIMER - Members are accountable for their own content.