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
Solved! Go to 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.
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
I was able to solve the next scenario.
Thank you