Hierarchy Rules for Inconsistent Data Set

Question

Alteryx Community,

I am trying to build a hierarchy with somewhat inconsistent data (i.e. one hierarchy might have six tiers and the next one only has four). Here is a mock of what I am looking for

Current

Tier 1

Tier 2

Tier 3

Tier 4

Tier 5

Tier 6

1

B

C

D

E

F

2

E

F

3

F

4

C

D

E

F

5

H

I

F

Desired Output

Tier 1

Tier 2

Tier 3

Tier 4

Tier 5

Tier 6

1

B

C

D

E

F

2

E

F

3

F

4

C

D

E

F

5

H

I

F

Here is some additional information:

* Tier 1 will always start with a numeric value
* “F” will always be the highest tier
* Tiers are in the appropriate order

Please let me know what your thoughts are- thank you in advance for the support.

Sample Data Set.xlsx

AbhilashR · Accepted Answer

Hi @felixcaspari, attached is a sample workflow that achieves the final output you are looking for. I am not sure if I am addressing the heart of what you are looking to do or if my solution will even process your larger dataset, but the approach built here-in may act as a good starting point.

Please let us know if there are other nuances to your dataset that need to be incorporated in our logic suggestions.