Hierarchy issue

Two Stars

Hierarchy issue

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


Re: Hierarchy issue


Could you please let us know if this article helps?


Best regards



Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.