Change a manual data connection to a scheduled event

  1. On the Flow Tool, go to the Connection refresh gallery and select the Manual box.
    If you don't have a manual connection, go to Common tasks using the Base Tool and select Set up a connection to Microsoft OneDrive® for an example of how to set one up.
  2. From Type, select Scheduled.
  3. Choose the frequency and time. For example, if you select Daily for Frequency and 02:00 for Hour/Minute, the data connection will update every day at 2 in the morning.
  4. Choose the start date, time zone, and end date. If you do not select a start date, the default is the current day. If you do not select an end date, the scheduled event will continue indefinitely. You can change your default time zone in your Account Settings under the The Minitab Connect interface .
  5. Select OK.

Add a data process to trim whitespace from data

  1. On the Flow Tool, go to the Processes tab and select the plus sign next to Data Process.
  2. Name the process White Space Cleanup, and select Add Process.
  3. Name the process White Space Cleanup again, and under Type, select Transform.
  4. Under Transformation, select Trim Whitespace.
  5. Select the fields you want to include in the process, then select Add.
  6. Select the save button to save the process. When you return to the Flow Tool, you can add the White Space Cleanup data process to your flow.

Set up an automated export of a table

  1. On the Flow Tool, create a new flow and select .
  2. Set up your export and select Save.
  3. The export displays on the left side of the Outputs tab. You can add the export to your flow.

Remove duplicate values from a table

  1. On the Flow Tool, go to the Processes tab and select the plus sign beside Data Process.
  2. Name the process Remove Duplicates, and select Add Process.
  3. Name the process Remove Duplicates again, and under Type, select Deduplication.
  4. Under Deduplicate Fields, select the fields that you want to check for duplicate values.
  5. From Deduplicate Method, select whether to merge the duplicates or to remove the duplicates. If you merge them, select how you want to merge the remaining fields. If you remove them, select the criteria to keep the record.
  6. Select the fields you want to include in the process, then select Add.
  7. Select Add, then select the save button to save the process. When you return to the Flow Tool, you can select the Remove Duplicates data process to add it to your flow.

Create a new Auto Importer

Auto importers look for a specific file in an FTP server, SFTP server, or an email address. Every 10 minutes Minitab Connect pulls data from that file into a table.

  1. On the Flow Tool, go to the Input tab and select the plus sign beside Auto Import.
  2. Select Server, and select the server or email address you want to pull the auto importer from under Import Server. To set up a new server or email address:
    1. Select the Minitab Connect button .
    2. Select System.
    3. Select File Importer Locations.
    4. Select Add New File Importer Location.
  3. Select Info.
  4. Name the auto importer and save.
To finish the new auto importer, verify that the filename from the server or email uses the filename from the auto importer.
  1. On the Info tab, copy the filename without the extension under File Name.
  2. Use this filename in the appropriate location so that the auto importer can find the file. For example, provide the name to someone who places the file on an FTP server or change the name for an export you have set up.

Every 10 minutes, the auto importer looks for the file in the location and pulls in the data if it finds the file.

If you add a trigger, the filename changes. After you add or remove a trigger, use the new filename in the appropriate location. You can also use the Short File Name, which does not change when a trigger is added or removed.

Create a connection to Minitab Model Ops

Minitab Model Ops™ provides the ability to use a variety of sophisticated models to make predictions. You can set up a connection so that anytime you add records to a table, Connect sends the new data to Minitab Model Ops. Then Minitab Model Ops generates predictions for the new data and sends the predictions back to Connect. Finally, Connect stores the new predictions in the original table.

Note

You cannot create a connection using mashup tables, SQL tables, or tables that you prep with an aggregate function.

  1. On the Flow Tool, create a new flow and add a New Flow Item.
  2. From the Type drop down, select Model Scoring (Minitab Model Ops). Select a view from the View drop down or select None.
  3. Under API Key, enter the API key for the Minitab Model Ops model. When you create an API key in Minitab Model Ops, there are two available scopes; Manage Models and Score Models. The key that you enter in Connect must have both scopes. For more information about how to get an API key in Minitab Model Ops, go to Getting Started with Minitab Model Ops and select "Manage API Keys".
  4. From the Model drop down, select the model that you want from Minitab Model Ops.
  5. Under Model Features and Model Responses, pair the parameters from Minitab Model Ops with fields in Connect. Pair a field for the MTB correlation ID, each predictor, and the predicted response. If you have a categorical response, also pair a field for the predicted probability for each class in the response variable. If you do not pair a parameter with a field, Connect does not store the data for that parameter in the table when you send new data to Minitab Model Ops.
    Note

    If you do not have a field for each Minitab Model Ops parameters, you can use the Base Tool to add new fields to your table. For more information, go to Common tasks using the Base Tool and select "Add data fields to an existing table".

  6. To run the connection each time you enter a new record into the Connect table, select the Manual box. From the Type drop down, select Data Event. Under Event Type, select On Inserted Records.
  7. Name the flow and save.

When you add a new record to the table, Connect sends the data to Minitab Model Ops. Minitab Model Ops generates predictions and sends them back to Connect. Connect stores the new values in the table.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy