Table of Contents

Search

  1. Preface
  2. Components
  3. API collections
  4. Business services
  5. File listeners
  6. Fixed-width file formats
  7. Hierarchical schemas
  8. Industry data service customizer
  9. Intelligent structure models
  10. Refining intelligent structure models
  11. Mapplets
  12. Saved queries
  13. Shared sequences
  14. User-defined functions

Components

Components

Edit the structure of Microsoft Excel input

Edit the structure of Microsoft Excel input

When the input of a model is a Microsoft Excel file, by default,
Intelligent Structure Discovery
doesn't include the metadata of the Excel spreadsheet in the structure, including the name and index number of the spreadsheet.
To include the spreadsheet name or index number in the structure, on the
Visual Model
tab of the
Intelligent Structure Model
page, right-click the sheetName or sheetIndex node, respectively, and select
Include in Structure
.
On the input data panel of the
Intelligent Structure Model
page,
Intelligent Structure Discovery
shows the model data in table format. When you hover over the table, the
Edit
button appears. Clicking the button opens a menu that you can use to perform the following actions on the table:
  • Transpose the table, that is, change the orientation of table headers from rows to columns or from columns to rows.
  • Convert a two-column or a two-row table to name-value pairs and convert name-value pairs to a table.
  • Define table headers.
The following figure shows a sample input data panel for a Microsoft Excel input file and the menu that you use to edit the table:
In this image, the input data panel shows a Microsoft Excel table without headings. The menu is open and shows the apply, transpose, convert to name-value pairs/convert to table, remove all headers, and cancel buttons.
  1. Apply
  2. Transpose
  3. Convert to name-value pairs/Convert to table
  4. Remove all headers
  5. Cancel

0 COMMENTS

We’d like to hear from you!