You 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.
This looks like a question from a test or some sort of training. You may find that this will not be answered unless you give it a go and break the project down into smaller questions.
