SAC Modeler - load data into a model - defines blank as '<root>'

[Eladtayarr]

In SAP Analytics Cloud (SAC) Modeler, whenever I load data into a model from an Excel file that includes blank values in a certain column, the system automatically defines everything that is blank as '<root>' in the hierarchy.
Is there a way to disable this?
So that blank values appear as they are (for example, an empty cell or another value I define) instead of creating the '<root>' entry in the hierarchy.

Any guidance or suggestions would be greatly appreciated!

[William_Yu · Accepted solution]

It's a current limitation. One workaround: split data load into two jobs: 

1. Job 1 with data having parent member value for that hierarchy, map the column to hierarchy property 
2. Job 2 with data having parent member empty, DON"T map hierarchy property in this case. 

[Eladtayarr · Accepted solution]

Thank you so much for your help!