top of page

Tech Blog # Talend - Transpose Rows into Columns

Writer's picture: nayan sharmanayan sharma

Updated: Mar 14, 2020

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


1,044 views0 comments

Komentarze


You are Awesome! Thank You for joining us!

  • facebook
  • Twitter
  • instagram

©2019 Learning Sutras by Mitali Badkul & Nayan Sharma

DISCLAIMER - Members are accountable for their own content.

bottom of page