Data Preparation - Hierarchy

[Ragini1]

Hi All,

Can you please help me in building the below workflow:

Input

Level 1	Level 2	Level 3	Level 4
A
A	B
A	B	C
A	B	C	D
A	B	C	E
A	X	Y
A	Z

Output:

Level 1	Level 2	Level 3	Level 4	Comment
A
A	B
A	B	C
A	B	C	D	Base
A	B	C	E	Base
A	X	Y		Base
A	Z			Base

Regards

[KarolinaRoza · Accepted solution]

Hi @Ragini1 ,

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.

[Ragini1]

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

Level 1	Level 2	Level 3	Level 4	Comment	Node Value
A
A	B
A	B	C
A	B	C	D	Base	D
A	B	C	E	Base	E
A	X	Y		Base	Y
A	Z			Base	Z

How to do it? really appreciate your help

[Ragini1]

I was able to solve the next scenario.

Thank you