I need to take the input sheet as a Talend job input and create the output as shown in sample_out sheet.
The idea is creating Levels for a company's Chart of Accounts. You are basically doing row-to-column oprations, though you need to maintain the hierarchy with a Generalized Talend job.
Avoid using Talend fully as a programming interpreter for this task i.e; Don't code it in java and run it over Talend
Could you please let us know if this article helps?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.