Hi All, Can you please help me in building the below workflow: Input Level 1Level 2Level 3Level 4A AB ABC ABCDABCEAXY AZ Output: Level 1Level 2Level 3Level 4CommentA AB ABC ABCDBase ABCEBaseAXY BaseAZ Base Regards

Data Preparation - Hierarchy

Hi All,

Can you please help me in building the below workflow:

Input

Output:

Regards

Datasets

Preparation

Could you provide more details about the logic when Comment should be assigned?

I suppose 'Base' is assigned if Level_4 is not empty and then going forward when next rows as well.

I created the workflow which 1. assign the number of last level then 2. assign comment.

It is created for 4 columns.

Let me know if it works for you.

Could you provide more details about the logic when Comment should be assigned?

I suppose 'Base' is assigned if Level_4 is not empty and then going forward when next rows as well.

I created the workflow which 1. assign the number of last level then 2. assign comment.

It is created for 4 columns.

Let me know if it works for you.

This logic works for me. If I want to populate the base node value too.

How to do it? really appreciate your help

I was able to solve the next scenario.

Thank you