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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.