Hello Alteryx Community,
I'm in need of your expertise and guidance! I'm currently working on automating a somewhat complex manual process that entails converting a hierarchical structure into a tabular format. I've attached a sample file that consists of two tabs: "Input" and "Output." This sample data exemplifies a parent-child relationship that spans across various business units and segments. It's important to note that beyond this sample dataset, the actual hierarchy extends to a total of 12 levels.
I'm wondering if it's feasible to transform this hierarchical structure into a tabular format using Alteryx. Your insights, tips, and advice on this matter would be greatly appreciated!
Thank you in advance for your assistance.
