I have a spend file that includes a category of spend at 1 of 4 possible levels (L1-L4) for every single record. I have the taxonomy file that lists all the possible combinations of L1-L4. Column A is L1, Column B is L2, etc... What I would like to do is specify the L2 from the Taxonomy file and see every record from the spend side that rolls up to that L2. For example, if my taxonomy looks like this: * Toys (L2)* Lego (L3) * Transformers (L3)* Generation 1 (L4) * Generation 2 (L4) * Dolls (L3)* Barbie (L4) * American Girl (L4) * Something else (L2) * Another Something else (L2) and I want everything from the spend that is in any category below (and including) Toys (L2), how can I do that without creating a filter and explicitly including the 8 possibilities? I'd like to make this repeatable where I can just say "show me Toys (L2) and it works. Appreciate any pointers! Thanks.

Matching Spend Data to Taxonomy Parent Categories Using Child Categories

I have a spend file that includes a category of spend at 1 of 4 possible levels (L1-L4) for every single record.

I have the taxonomy file that lists all the possible combinations of L1-L4. Column A is L1, Column B is L2, etc...

What I would like to do is specify the L2 from the Taxonomy file and see every record from the spend side that rolls up to that L2.

For example, if my taxonomy looks like this:

Toys (L2)
- Lego (L3)
- Transformers (L3)
  - Generation 1 (L4)
  - Generation 2 (L4)
- Dolls (L3)
  - Barbie (L4)
  - American Girl (L4)
Something else (L2)
Another Something else (L2)

and I want everything from the spend that is in any category below (and including) Toys (L2), how can I do that without creating a filter and explicitly including the 8 possibilities? I'd like to make this repeatable where I can just say "show me Toys (L2) and it works.

Appreciate any pointers! Thanks.

Help

Accepted answers

IraWatt

Hey @TeamTJ,

From looking at your output I think this captures your logic (workflow linked below):

If you have any questions on how it works make sure to ask

HTH,

Ira

L2 join.yxmd

All comments

IraWatt

Just to try and understand the question are you looking for a hierarchy structure similar to something like this Solved: Displaying Hierarchy of Managers - Alteryx Community ? Could you show an example output table you would want?