I have the following data in Excel (this is a much simplified example):
Name |
Group |
Parent |
A |
X |
B |
B |
X |
D |
C |
X |
B |
D |
Y |
|
E |
Y |
D |
F |
Y |
D |
G |
Z |
D |
H |
Z |
G |
I |
Z |
G |
J |
Z |
G |
K |
Z |
G |
I import it as an Edge List and a Node List, using:
-
Edge List
-
Name as the Column of Source IDs
-
Parent as the Column of Target IDs
-
Node List
-
Name as the Node IDs
-
Group as the Group Node IDs
I get a tree, with the correct nodes imported, correct parent-child edges, and correct groups.
But I want the Group value to be the label at the top of each Group. When I look at the data for each node, I see that in the regular Nodes the "Name" value is empty, when it should be the value in the first column. In Group Nodes, the Group value (X, Y, Z) is in the Name attribute, instead of in the Group attribute. I think this is incorrect and might be a bug.
I thought perhaps it was something to do with importing groups, so I try again without identifying the Group Node IDs:
-
Edge List
-
Name as the Column of Source IDs
-
Parent as the Column of Target IDs
-
Node List
-
Name as the Node IDs
-
Group Node IDs BLANK
This time I get the tree again, with no groups as expected. Checking the node data attributes, I see that Name is correctly set, Group is correctly set, and also Parent is correctly set.
Is there a way around this issue? I have a large tree to import from Excel, and I really want to be able to generate and import the node names and their groups, and be able to label the groups automatically.