Change a manual data connection to a scheduled event
-
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.
- From Type, select Scheduled.
- 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.
-
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
.
- Select OK.
Add a data process to trim whitespace from data
-
On the
Flow Tool,
go to the
Processes
tab and select the plus sign
next to
Data Process.
- Name the process White Space Cleanup, and select Add Process.
- Name the process White Space Cleanup again, and under Type, select Transform.
- Under Transformation, select Trim Whitespace.
- Select the fields you want to include in the process, then select Add.
-
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
- On the Flow Tool, create a new flow and select .
- Set up your export and select Save.
- 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
-
On the
Flow Tool,
go to the
Processes
tab and select the plus sign
beside
Data Process.
- Name the process Remove Duplicates, and select Add Process.
- Name the process Remove Duplicates again, and under Type, select Deduplication.
- Under Deduplicate Fields, select the fields that you want to check for duplicate values.
- 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.
- Select the fields you want to include in the process, then select Add.
-
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.
-
On the
Flow Tool,
go to the
Input tab and select the plus sign
beside
Auto Import.
-
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:
-
Select the
Minitab Connect
button
.
- Select System.
- Select File Importer Locations.
- Select Add New File Importer Location.
-
Select the
Minitab Connect
button
- Select Info.
- Name the auto importer and save.
- On the Info tab, copy the filename without the extension under File Name.
- 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.
- On the Flow Tool, create a new flow and add a New Flow Item.
- From the Type drop down, select Model Scoring (Minitab Model Ops). Select a view from the View drop down or select None.
- 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".
- From the Model drop down, select the model that you want from Minitab Model Ops.
-
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".
-
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.
- 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.