Skip to main content

Edit Children

Edit Children opens all children of the selected node in an Excel-like grid. Nothing is saved until you click Save changes, and then everything is saved in one transaction.

To open it, select the parent node and click Edit Children in the Children action box. You need Modifier on the node to change values; adding and deleting rows needs Manager, and the Owner and Steward columns need Governor (see Security).

The Edit Children grid

Columns and rows​

  • Columns are the union of the children's properties. A hatched cell means the property is not defined by that row's types — add the type to fill it.
  • Explode children: off, 2 levels or 3 levels. Each grandchild gets its own line; the parent cells repeat in grey and still edit the parent.

Golden records with their source records exploded

  • The grid loads 40 children at a time; Load next 40 at the bottom loads more.
  • Drag a header to move a column; Hide it from the column menu; hidden columns come back from the toolbar.

Sorting and filtering​

Click a column's filter button:

  • Sort A→Z / Z→A — on child columns the sort runs on the server over all children.
  • The value list shows the values of all children with counts (the first 40; search for more). Typing in the search ticks the matching values, so OK filters to them right away; (Select all search results) ticks or unticks all matches.

The column filter

Editing​

Do thisHow
Edit a cellDouble-click it, press Enter or F2, or just start typing
MoveArrow keys, Tab / Shift+Tab; Shift+arrows extends the selection
Toggle a BooleanSpace or double-click
Clear cellsDelete or Backspace on a selection
Undo / redoCtrl+Z / Ctrl+Y (or Ctrl+Shift+Z), or the toolbar buttons
Add a childAdd child, or click the empty row at the bottom
Delete rowsTick the rows (or select cells) and click Delete rows; click again to undo
RevertRevert changes discards every unsaved change

New rows are green, modified rows orange, deleted rows struck through. The footer counts them.

Copy and paste​

Ctrl+C copies the selection with a header row; Ctrl+V pastes from Excel or CSV. A header row maps columns by name. With a UID column, a known UID updates that row; a UID that is not loaded is sent to the server, which updates the node if it is below this one and otherwise creates a new child. Paste rows… creates many children at once from pasted text.

PropertyTypeCopied asAccepted on paste
StringACME GmbHany text
Number12001200, 1 200, 1,200
Float1500.51500.5 or 1500,5
Timestamp2026-11-15 09:30ISO, 2026.11.15., 15.11.2026, 15 Nov 2026, 20261115, Excel serial, Unix seconds…
BooleanTRUE / FALSEalso yes/no, 1/0; empty = FALSE
Enum(X)Germanythe value's name (any case) or its UID
Link(X)Berlinname or UID; use the UID if a name is not unique
Array(NodeType)Germany, Austriacomma- or semicolon-separated names or UIDs
Array(String)key account, eucomma-separated; quote a value with a comma

Values that do not parse or resolve stay as typed and turn red; Save is blocked until they are fixed.

Saving​

Save changes validates everything on the server first. If any row fails, nothing is saved and the rows with errors are marked. If someone else changed one of the nodes since you loaded it, the save is refused — reload and apply your change again.

Tips​

  • Use Explode children on a Master Data node to correct golden records and check their source records side by side.
  • To fill one property for many children, copy one cell, select the target cells in the column and paste.
  • Big changes are easiest in Excel: copy the grid with headers, edit in Excel, paste back — the UID column makes every row update the right node.
  • Corrected values become UserDefined — see Modifying data.
  • Value formats for Enum, Link and Array cells are explained in Enum, Link and Array.