Creating groups from data import (datalink)

3.87K viewsDataLink

Hi. I have a matrix of accounts grouped. This matrix is supposed to be loaded into the database and used in various models.
When i load data from the database, the Empty values appears in the groups.

How can hierarchy levels be kept in groups?

braddo Posted new comment July 20, 2020

Can you upload your model and I can take a look and try to figure out a solution for you…


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)

Dear Clod Answered question April 21, 2020



VV Hi,
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

S A U Answered question August 19, 2019

Latest Questions