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
... View more