Add a value to the dropdown list in an existing list field

  1. Open the table, go to the Base Tool , and select the Setup tab.
  2. Find the appropriate list field and select the expander.
  3. Scroll down to Values. Enter the values you want to add. Put each value on a separate line. You can expand the length of the box by selecting and dragging the bottom right corner of the box. For more information on the field settings you can change, go to Field options for the Base Tool.

Add data fields to an existing table

  1. Select the Minitab Connect button to open the Navigation pane. Select Tables, and browse to the table to which you want to add a field.
  2. Select the Base Tool .
  3. Select Click to add a field, and enter the information for the field in the box that appears underneath. Select the expander to access additional settings for the field.

Import data to a new table from an Excel file

For this example, use the data set in the Minitab Data Set Library, Online Downloads Data.

  1. From the Home screen , select the Minitab Connect button to open the Navigation pane. Under Tables, select Add New Table. Or, from the Home screen, select the Add button under Tables.
  2. From the Tables gallery, select File/Text/Template.
  3. Under Import Type, select File and select to browse to your file.
    Note

    Close the file before you import it. Minitab Connect only imports the first sheet of an Excel file.

  4. On the left side of the screen, type Online Downloads for Name. Select or type a Folder location.
  5. Select Save .
When you save the table, the Prep Tool opens. Select Reset Config to view the data.
Note

Select the Notifications and Issues button to display problems with your data. For instance, you can see whether the data have been imported properly.

Note

After you import the file, the data in Minitab Connect is independent of the original data file. Therefore, changes made to one source will not affect the other.

Create a new table from two tables with Mashup

Use a mashup table to combine data from multiple tables. For example, suppose you upload measurements of parts at two different stages of the production into two separate Minitab Connect tables.

  1. From the Home screen, select the Add button under Tables. Give the table a name, such as Measurements Combined, and select folder in which to save it.
  2. From the Tables gallery, select Mashup.
  3. From Link Type, select All Records under Horizontal. For more information on the difference between a horizontal and vertical mashup table, go to Mashup table options for the Base Tool.
  4. Select the pre-existing table Part Measurements for the Primary Table, and Coating Measurements for the Linked Table. The two tables share the field Part Number. Select the link button beside the first instance of Part Number, then select the check mark beside the second instance. Save the table.
  5. The new table includes two identical fields, Part Number and Part Number(1). To remove the second field, return to the Base Tool and select the Advanced tab. Select the remove field button to gray out the Part Number(1) field and save the table. When you return to the Prep Tool, only one Part Number column appears.

Create a new table from a connection to Microsoft OneDrive®

You want to set up a connection from Minitab Connect to the spreadsheet in OneDrive® and update the data every day at 7am. For this example, use the data set in the Minitab Data Set Library, Central shipping center data.

  1. From the Home screen , select the Minitab Connect button to open the Navigation pane. Under Tables, select Add New Table. Or, from the Home screen, select the Add button under Tables.
  2. Add a Name for the table and select a Folder description.
  3. In the list of galleries that begins with Tables and Analytics and Optimization, scroll to the Documents, Collaboration, File Sharing & Email gallery and select OneDrive.
  4. Under Connection, choose New Connection.
  5. Under Name, enter Central Shipping.
  6. Select Authorize Microsoft Account and enter the credentials for your account. Then select Save .
  7. From Update Frequency, choose Daily. Select the calendar button under Hour/Minute, select 7am, and select OK.
  8. Under Drive, select the OneDrive connection that you just authorized. Select Next.
  9. Under Files, select the folder you saved the Excel file in. Select Next. If your file is nested in multiple folders, you will have to do this step for each folder.
  10. Select the Excel file. In this case, select central.xlsx. Select Next.
  11. Select Save .

If you go to the Prep Tool and select Run , Minitab Connect displays the central shipping table.

Create a new table from an existing table with Custom SQL

  1. From the Home screen, select the Add button under Tables.
  2. Add a Name for the table and select a Folder description.
  3. From the Tables gallery, select Custom SQL.
  4. Add your SQL code. You can select Show Table List to add SQL from an existing table.
  5. Select Run SQL to generate a preview of the table. When the table looks correct, select Save .