Talend - Transpose Rows into Columns

Talend - Transpose Rows into Columns

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
www.learningsutras.net

Comments

Post a Comment

Popular posts from this blog

JEZEBEL - CHAPTER 1 : LIFE THAT LOVES YOU AT LEARNING SUTRAS

Image
Jezebel Chapter 1: LIFE THAT LOVES YOU ‘Deserted, in the mizzle Drops chisel, my tears concerted Drizzle tears my soul demented Torment of your loss, abyssal’ Tear rolled down her cheek as she clutched the eulogy she never spoke. “Are you alright?” asked his dad, searching for her eyes through the rear-view mirror. “Keep your eyes on the road dad” she replied, face down. “I am very happy that you’re finally seeing someone Jez”. “We will see how far that goes dad” she replied, still facing down. “Great! Air conditioning is down again. Do you want me to open windows for you? I know you don’t like them closed” Jezebel looked at him, carrying her chin up “No, unless you want him to never call me after today. I hope you understand that besides whatever I am not, nothing is really going to make him call me ”. Her eyes teared up again, just this time she didn’t want to ruin her makeup. She has to get this right. Still clutching the pape...
Read more

YOUTUBE CHANNEL FOR CLASS 9 NCERT BASED FREE VIDEOS

Image
Hey There!! SUBSCRIBE TO OUR YOUTUBE CHANNEL FOR FREE VIDEOS - CLASS 9 - NCERT BASED CLICK HERE for Resources for Chapter 8 - Science - Motion CLICK HERE for Chapter 9 - Friction and Laws of Motion For Feedback/Suggestion/Queries - Comment below or write to us on learningsutras@gmail.com #learningsutras #ncert #cbse #onlinevideos #freecontent #impnotes #notes #solutions #class_9 #science youtubevideos
Read more