Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space FUNCTDEV and version SVC2021.1

...

NameSpecifies the name for the node.
Data SourceSpecifies the Excel workbook used to initialize the data (see Configuring Initialization Options). If the None option was enabled, this field will be empty and data will need to be added manually using the data source editor (see Viewing and Modifying the Repository Structure and Contents).
Sheet NameSpecifies a sheet name when importing from Excel.
Join Column

Specifies the name of the column used for indicating relationships across Excel sheets. By default, the ParentIndex column is used (see Defining the Structure). 

If the value in a record’s Join Column matches the value in a Parent Join Column record, then that record becomes a child of the parent record.

This setting is not available for column-level nodes. 

This setting cannot be configured for worksheet-level nodes at the root of the tree.

Parent Join Column

Specifies the column in the parent node used for indicating relationships across Excel sheets. By default, the value is set to <Row Number>, which specifies that the column correlates to the parent row number. 

If the value in a record’s Join Column matches the value in a Parent Join Column record, then that record becomes a child of the parent record.

This setting is not available for column-level nodes. 

This setting cannot be configured for worksheet-level nodes at the root of the tree.

Data ColumnSpecifies name of the column containing the data.
Field Type

Specifies which type the data should be imported as. You can specify one of the following types:

  • Record List: Series of complex records that are hierarchical and have multiple fields/columns.
  • Primitive List (see Support for fro Primitive Lists): A list of primitive types.
  • Array: An array of primitive types.

See Viewing and Modifying the Repository Structure and Contents for additional information about types.

...