Multilevel Product Hierarchy

[AniK]

Hello,

I am trying to create a multi level product hierarchy but I am not sure how to generate the additional rows. Currently, I have an input file with entries highlighted in green and I would like to generate the full hierarchy with all entries (highlighted in green and yellow). I have also attached the input and required output file for your reference.  Input FileOutput file

[jasperlch · Accepted solution]

Hi @AniK 

This is an interesting challenge. A combination of Transpose, Cross Tab, Generate Rows, Unique tools should achieve what you need:

Hope this helps

[AniK]

Thank you so much @jasperlch! This solves my problem!

[agilleland17]

Hi, 

Thanks for this solution!

If I wanted to sum the on the different levels (i.e. create a higher level total of level 1 that breaks down) how would I do that? Thanks!

anne