Work with Tables The Table panel displays live searchable tables of the nodes and edges visible on the canvas for each Category or Relationship. In a table you can: Review the data for one category or relationship at a time. Scroll to skim properties and property values. Sort table rows by property values. Search property values in the full table or a specific column. Reformat table Columns to display only properties of interest in the order you want. Edit the data on the canvas Rename categories, relationships, and properties Edit or reformat property values Delete properties Delete nodes or edges currently selected in the table. Select and mark table rows for further action. Export a CSV or Excel file from selected table rows or from a selection on the canvas. Delete nodes or edges selected in a table from the canvas. Display a Table Tables include all data currently visible on the canvas for a single category or relationship. Data that has been hidden using Hide Selection is not included in a table. Each table row represents a single node or edge. Property names appear in column heading, and property values in the table cells. A current selection on the canvas is highlighted in the table. Show and review a Table To show a Table: Select nodes and edges of interest, or deselect all data on the canvas. Open the Table panel, and choose either Category or Relationship. Click a category (or relationship) name to display a table of the currently visible and selected nodes (or edges) of that entity. You can now: Review the nodes (or edges) and their properties in the table rows. Click Next or Previous page controls. Change the number of rows displayed per page. Use horizontal scroll bars to see all the properties in the table columns. Sort column property values in ascending or descending order. Search Property Values in a Table. You can search the entire table using the Full Search bar and/or search within a column by clicking the gray search icon. Both searches operate on whatever is already displayed. You can start with one, and narrow the search further with the other. To search a table’s property values: Enter a full table search or column search: For a full table search, enter a search term in the Full Search bar. The search term is highlighted in yellow wherever it is found in the table rows. The term remains in the Full Search bar until you remove it. For a column search, click a column’s gray search icon, enter a search term, and click Filter Rows. + + A column search term is not highlighted in the table. Instead, when a column search filter is applied, a blue icon replaces the gray search icon. Click the icon to show or refine the current column search, or click Reset to clear it. + + image::/v3/04_06_05_TableColumnSearchApplied.png[,520,180,role=text-left] The table displays only the rows matching the search. Optionally, click the Select checkbox in the column heading to keep the table rows selected after you clear search terms. To display the entire table again clear the Full Search bar and/or click the blue icon on column and click Reset. Reformat Table Columns By default, table columns show all the properties for the category or relationship in alphabetical order by property name. The Columns pop-up lets you to re-order or hide table columns at any time. This lets you: Review properties of immediate interest without having to scroll Format a table for export that includes only the properties you need. To reformat table columns: In an open table, click Columns for the list of available property names. Current property names are listed at the top, in the order they currently appear in the table column headings. Properties not currently displayed are listed below in gray text. Click the checkbox next to a property name to add (or remove it). Click the up or down arrows next to a displayed property name to re-order the table’s column headings. Click anywhere outside of the Columns pop-up to dismiss it. Edit Data in a Table In a table, you can edit most elements of your data, including: Rename a category, relationship, and its properties. Edit or reformat property values Delete properties from nodes and edges on the canvas Delete nodes and edges from the canvas Editing a table takes immediate effect on the data on the canvas and cannot be reverted. However, it affects only the data on the canvas, not in saved views or the internal database. Before editing, and especially before deleting selected data or deleting a property, save a View or take a Snapshot. Then if you’ve removed data by mistake, you can restore it. Rename a Category or Relationship Renaming a category or relationship in a table immediately changes the label for Data visible on the canvas. Any data hidden using Hide Selection. To rename a category or relationship: Open the Table panel, and on the category or relationship bubble, click the pencil icon. Enter the new name, and press return. The new name appears immediately in the Table panel, legend, and in the Project > Category or Project > Relationship tabs. Rename a Property Renaming a property in a table immediately changes the name only for the data visible on the canvas. The property name is unchanged for data of that category or relationship currently hidden using Hide Selection. To re-name a property using a table: Open the Table panel, and click the category or relationship bubble to display its table. Locate the property name, click the settings icon in its column, and select Rename. Enter the new name in the column heading, and press return. Edit Property Values in a Table Editing a property value on a table immediately changes it on the node or edge on the canvas. You can also open an Information window for a single node or edge to add or delete (but not rename) its properties and edit their values. To edit a property value in a table: Open the Table panel, and click the category or relationship bubble to display its table. Optionally, search the table, or select a node or edge on the canvas. In the table, click in the appropriate table row and property value cell. Enter a new value and press return. Delete a property using a Table Deleting a property in a table immediately deletes it from all the data on the canvas, but not from any hidden data, saved views, or the connected database. To add or delete properties from specific nodes or edges, you can also select data on the canvas and open an Information window. To delete a property using a Table: Open the Table panel, and click the category or relationship bubble to display its table. In the table, locate the column for the property you want to delete. Click the column settings icon, and select Delete from the menu. The property is immediately deleted from all nodes (or edges) of that category (or relationship) currently visible on the canvas. Delete Nodes or Edges using a Table You can delete nodes or edges by selecting them in a table and deleting them. This deletes the nodes or edges from the data visible on the canvas, but not from saved views or the connected database. For a workflow where you need to clear out specific subsets of data temporarily, deleting data using tables can be easier than using the selection options available on the canvas. To select and delete nodes or edges in a table: Open the Table panel, and click the category or relationship bubble to display its table. If data you want to delete is selected on the canvas, you must select it on the table before you can delete it. Click Show selection only, Click the checkbox in the first column heading to select the items in the table. Click Show selection only again to display the full table and select or de-select additional table rows. In the table, you can locate nodes or edges to delete through inspection or a search. Click the checkbox in the first table column to select a table row, or click the checkbox in the column heading to select all the rows returned through a search. Open the More Actions menu and choose Delete Selected from Graph. The nodes (or edges) selected in the table are immediately deleted from the canvas. If you might want to restore the canvas as it was before deleting the data, don’t save the current view. Instead, choose Save As to save a new view. Select and Mark Data in Tables You will likely want to create a specific table of nodes or edges either for export, or to highlight a subset of the nodes (or edges) on the canvas for further exploration. In the Table panel you can combine search and selection options to: Select data on the canvas and/or in a table, and refine the table selection. Mark the selected table on the canvas. This replaces the current selection on the canvas with the selection in the table. To select data and mark the selection on the graph: Open the Table panel, and click the category or relationship bubble to display its table. If data you want to mark is selected on the canvas, you must select it on the table before you can mark it. Click Show selection only, Click the checkbox in the first column heading to select the items in the table. Click Show selection only again to display the full table and select or de-select additional table rows. In the table, you can locate nodes or edges to delete through inspection or a search. Click the checkbox in the first table column to select a table row, or click the checkbox in the column heading to select all the rows returned through a search. Open the More Actions menu and choose Mark Selected in Graph. The table now displays the marked rows The badge on Show selection only badge shows the new number of items currently selected on the canvas. On the canvas, you can continue working with the new selection (for example, using tag, annotate, layout options, and more). Export a CSV or Excel file from a Table You can export a flat CSV or Excel file with all or part of a current table to your local system. This exports the table of the nodes or edges currently selected in the table with the current column formatting. This can be useful, for example, when inspecting data for outliers or errors, since the exported file will include only the properties defined for the category or relationship that you need to review. Hidden data, any properties not currently displayed in the table, and properties marked as Exclude in the Project panel and Category (or Relationship) tabs are not exported. To export a CSV or Excel archive: Open a table for a category or relationship. Select the table rows to export using any selection method, including: Selection in the table or on the canvas. Full table search and/or column filtering. On the More Actions menu, choose either: Export Selected as CSV to download a flat CSV file. Export Selected as Excel to download an .xlsx file.