Hi All,
I'm putting together a workbench to run a multi criteria analysis (MCA) based on a hierarchy (hierarchy level 1, 2, 3, 4, 5, 6, etc). The conditional values in the Attribute creator will help me with that. The problem is that some of the values of the hierarchy need to the next level of the hierarchy . Here is the hierarchy that needs to be followed:
- Hierarchy Level 1
- Hierarchy Level 2
- Hierarchy Level 3
o Exception A : Any record in level 3 is ‘No main habitat’ will go to level 4 in the hierarchy, if level 4 is empty then goes to level 5, if level 5 is empty then goes to level 6, if level 6 is N/A then goes to level 7.
- Hierarchy Level 4
- Hierarchy Level 5
o Exception B: Any record in level 5 is ‘Individual Tree’ then goes to next level 6 in the hierarchy, if level 6 is N/A then goes to level 7
- Hierarchy Level 6
o Exception C: Any record is N/A then goes to next level 7 in the hierarchy.
- Hierarchy Level 7
The following screenshot shows the conditional statement for a basic hierarchy from 1 to 7 (with no exception A, B and C):
...but I need to include exceptions A, B and C. This is what I have tried with no luck:
I'm pretty sure it's doable with a conditional statement but need some help with the expressions as I'm not able to make exception A, B and to happen in order!
Any help more than welcome! 🙂
