The Extract transform lets you generate nodes and edges belonging to new or existing categories and relationships, based on one or more source properties.
Examples use the open-source dataset for the HBO series Game of Thrones. For a hands-on exercise, see our How to GraphXR tutorials.
The Characters.csv file tabulates information about each character in the series, the name and the house they belong to. Importing CSV file assigns all the data to a single default Characters category, but we want to extract a separate House category for the family each character belongs to.
We can extract a houseName property from Character nodes, and use it to create both a House category and a new BELONGS_TO relationship linking House nodes to the original Characters nodes.
To extract a new category and connecting relationships:
In the graph space, de-select the data to extract from the entire data set.
NOTE: If you select nodes, Extract operates on only those elements. With nothing selected, transformations affect the whole graph.
Open the Transform panel and Extract tab, and enter the following details:
• In the Extract From Category menu, select Characters, which will appear as the Source Category. If there is only one category in the graph, it is already entered as the Source Category, and the menu does not appear.
• In the New Relationship textbox, enter BELONGS_TO.
• In the New Category textbox, enter House.
• In the Create Category From Property area, select the houseName property from the menu (or click the + (plus) icon next to its name in the table below) to add it to the Selected Property list.
NOTE: Properties in the source data are listed alphabetically in the scrollable list of properties. A sample of data displays below the property names, showing property values and data formats.
The selected property name appears in the New Property Name text box. Leave it unchanged for this example.
Click the Key checkbox to set houseName as a key, so that a single node will be created for each unique value of houseName, rather than a separate one for every source node.
NOTE: If the property value is a list and not a single value, you can click the Split checkbox to create a separate node for each value in the list. Otherwise, a single node will be created with only the first value in the list.
Optionally, you can specify additional details for the extracted nodes:
• Click SkipEmpty to extract the specified pattern only when the source property is present and its value is non-null. For example, the (Character)-[BELONGS_TO]-(House) pattern would be created only for Character nodes that include a houseName property and value.
• Click Inherit Links to copy any edges connected to the original category to the new extracted category. Our graph does not yet include any edges so we’ll leave it unchecked.
Scroll down to the bottom of the panel and click Run.
A scrolling list below the Run button displays errors and a completion message for the Extract.
The legend now displays the new House category, and the new BELONGS_TO relationship.
Extracted House nodes appear in the graph space, connected to their respective Character nodes by new BELONGS_TO edges.
Since we left Skip Empty unchecked, source nodes with no houseName value are assigned to an unlabeled House node, connected to their respective Character nodes through BELONGS_TO edges. In the Property list, the houseName property of the unlabeled House node appears as “not available”.