Excel Add-In for Avro

Build 24.0.9029

Parsing Hierarchical Data

The add-in offers three basic configurations to model object arrays as tables, described in the following sections. The add-in will parse the document and identify the object arrays.

  • Flattened Documents Model: Implicitly join nested object arrays into a single table.
  • Relational Model: Model object arrays as individual tables containing a primary key and a foreign key that links to the parent document.
  • Top-Level Document Model: Model a top-level view of a document. Nested object arrays are returned as strings.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9029