Creating a Data Designer Table from an Imported Excel File

Browse your computer for an existing Microsoft Excel file, then use this file to import table structures and data into the Import from Excel interface, within Data Designer.

Make sure your chosen Microsoft Excel file has been saved, using the correct file format.

Implementation:

  1. Click in the Activity Bar of the main KnowledgeKube window.
  2. Select the Tools menu at the top of the window, and click Import from Microsoft Excel.
  3. (Optional) Click the Learn More About Importing Data From Microsoft Excel link, for more information about the excel importing process.
  4. Click the Browse for File button.
  5. Choose a file and click Open.

Depending on the size, number of worksheets and overall complexity of the selected file, you will see a progress indicator while the intended file is being processed.

  1. In the Import from Excel window, click Import next to the intended worksheets.
  2. (Optional) Tick the Include Data check box next to the worksheet(s) you want to import, so the data will be included in your new Data Designer table when the import process has finished.
  3. Click Start Importing.
  4. When prompted, click OK to proceed.
  5. When prompted, click OK to create a copy of the selected excel table, into the Data Designer.
  6. Click OK to verify the table you want to create.

View and manage your new table in the Definitions tab of the Data Designer.