Multilevel Product Hierarchy
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 File
Output file
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much @jasperlch! This solves my problem!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
