I have an alteryx WF which generates the below hierarchy, currently it is limited to 4 hierarhy but this can increase to 10. What I am unable to do is how I can delete the rows where the hierarchy is getting repeated.
For e.g. In the below I only need 1st 3 rows to be there, rest everything is a repeat, Row 1 record, X > Y > Z > A the hierarchy is getting repeated in Row 6
similarly Row2 is similar to Row4 and so on. So basically if the Level 2 > 3 > 4 record appears again in Level 1 > 2 > 3 then it should be deleted.
Tried multi row formula does not work as sorting the fields in Level 1 > Level 2 > Level 3 > Level 4 order will not result in the rows coming exactly in the prior row.
| Record | Level 1 | Level 2 | Level 3 | Level 4 |
| 1 | X | Y | Z | A |
| 2 | A | B | C | |
| 3 | A | D | E | |
| 4 | B | C | | |
| 5 | D | E | | |
| 6 | Y | Z | A | |
| 7 | Z | A | | |
