The second method seem not likely possible since some categories are category linked.
The first method seems to be the only automated solution for the category-linked model, but frustrating with the category outcome.
Output Grouped Category as mention.
Not in order for the new Items in Category (as attached)
1. As far as I understand, accounts’s hierarchy consists of four levels. But you left three of six hierarchy branches incompletely named. I have named all levels in all branches of the hierarchy and this is what I got for H2 DB by means of Data Import:
2. If you want to use a category Hierarchy in many other models, then consider use of the template instead of importing-exporting the matrix for this purpose: (FileSave As (select the ‘Quantrix Modeler Template File‘ option from the drop-down menu) )
Good luck, SAU