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
You may use Pivot component in Talend. Since I have not seen your sample data, I would not be able to tell exact solution for your use case. It may also require some sort of custom coding if the use case is complex.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
