DocumentationUser The Base ToolWhat is in the Base Tool?

What is in the Base Tool?

Minitab Connect - patch.tmmlog.in - Google Chrome

Toolbar options:

Reset.

Minitab Connect - patch.tmmlog.in - Google Chrome

Save.

Save As.

Export Template.

Lock.

Delete.

DATASET tab.

Fill in the required fields (highlighted for this example).  Other fields are optional.

Minitab Connect - patch.tmmlog.in - Google Chrome

Basic Table options.

Some of these options may not be available (based on the User settings):  

  • Standard Table - manually create a Table.
  • File / Text / Template Table - options for Importing data into a Table.
  • Mashup Table - combine Tables.
  • Custom SQL Table - available for Custom SQL options.
Minitab Connect - patch.tmmlog.in - Google Chrome
Example of Standard Table:

Select Standard, for this example.

SETUP tab.

Click to add a field.

Minitab Connect - patch.tmmlog.in - Google Chrome
Minitab Connect - patch.tmmlog.in - Google Chrome

The Type menu options:

  • Text
  • Long Text
  • Number
  • Date
  • List
  • File
  • HTML
  • ID
  • Sparkline

Expand/Minimize additional options for the Field.

Minitab Connect - patch.tmmlog.in - Google Chrome
Example of additional options.

These additional options are available when Date is selected from the Type menu:

  • Description
  • Format
  • Date Type
  • Custom SQL
  • Default Value
  • Index Field
  • Required
  • Readonly
  • Hidden
  • Disabled on Export
Minitab Connect - patch.tmmlog.in - Google Chrome

Required items.

For this example, we will look at Date (selected from the Type menu).  

Format and Date Type are both required items in this example (they have an asterisk after them).

Minitab Connect - patch.tmmlog.in - Google Chrome

The Format options in this example are:

  • Date
  • Date/Time
  • Time
Minitab Connect - patch.tmmlog.in - Google Chrome

The Date Type options in this example are:

  • User Entered
  • Insert Date
  • Update Date
Minitab Connect - patch.tmmlog.in - Google Chrome

Copy the Field.

This will make a Copy of the Field (and add it to the bottom of the list of current Fields).  The Copy button is available in the Minimized View and the Expanded View of the Field.

Minitab Connect - patch.tmmlog.in - Google Chrome

Remove the Field.

This will Remove the Field.  The Remove button is available in the Minimized View and the Expanded View of the Field.

Minitab Connect - patch.tmmlog.in - Google Chrome

Create a Table:

1. Add the Field(s).

2. Enter Field Name(s).

3. Select the Type of data to be used under the Field Name.

Minitab Connect - patch.tmmlog.in - Google Chrome
Example of File / Text / Template Table:

Select File / Text / Template, for this example.

Text example.

Select Text from the Import Type menu.

Minitab Connect - patch.tmmlog.in - Google Chrome

Have data from another location that you can Copy, then:

1. Paste Data into the Box.

2. Preview will display a Table of the data you pasted.

Minitab Connect - patch.tmmlog.in - Google Chrome

File example.

Select File from the Import Type menu, for this example.

Minitab Connect - patch.tmmlog.in - Google Chrome

1. Click the Upload File area to select the File you want to use.

2. A preview will display.

Minitab Connect - patch.tmmlog.in - Google Chrome

Template example.

Select Template from the Import Type menu, for this example.

Minitab Connect - patch.tmmlog.in - Google Chrome

1. Click the Upload File section to select your File.

2. Select the Share options from the menu.

Minitab Connect - patch.tmmlog.in - Google Chrome

If None is selected, then there are no further options in this section.

Minitab Connect - patch.tmmlog.in - Google Chrome

If Limit is selected, then you would select from the available User Group(s) to provide access to the File.

Minitab Connect - patch.tmmlog.in - Google Chrome
Minitab Connect - patch.tmmlog.in - Google Chrome
Example of Mashup Table:

Select Mashup, for this example.

Here are the options that open:

Minitab Connect - patch.tmmlog.in - Google Chrome

Let's look more closely at the Links.

Minitab Connect - patch.tmmlog.in - Google Chrome

Choose the Link Type from the options in the menu.  Select the Primary Table, then select the Linked Table.

Minitab Connect - patch.tmmlog.in - Google Chrome
Example of Custom SQL Table:

Select Custom SQL, for this example.

Here are the options that open:

    1. The SQL section.

    2. The Preview section.

Minitab Connect - patch.tmmlog.in - Google Chrome

SQL section.

Minitab Connect - patch.tmmlog.in - Google Chrome

There are two buttons available in the SQL section: Show Table List and Run SQL.

Minitab Connect - patch.tmmlog.in - Google Chrome

Save the changes.

Click the Save icon (in the top left section of the screen).

Minitab Connect - patch.tmmlog.in - Google Chrome
Minitab Connect - patch.tmmlog.in - Google Chrome