You can also create a new field type on the Processes tab. Almost anything that is a data process can be set as a field type. Creating a new field type can be helpful when you have custom code that you want to run. Your code may run better if it's saved in the database as a field type than as a data process. When you create and save a new field type, you can set a field to your new type using the Base Tool.
Double-click an existing data process to add it to your flow. Select the plus button 
to create a new data process or field type. For every type of
process, you can choose to always run the process, or to only run it based on specific
criteria. For example, you can chose to only perform the process if a date is before a
specified day or if the table has exceeded a specific number of rows. You can create the
following:
Action
Perform a find and replace on the data for a specific field. You can type in the replacement value, or you can enter your own SQL code.
Custom code (PHP, Perl, Python, SQL)
Run your own custom code. Custom code is only available to system administrators. Custom SQL is the only option available to development users.
Note
For PHP, Perl, and Python, only System Admin users and above can specify this process. For SQL, only Developer users and above and specify this process.
Call URL
Select to make an API request. For example, you could power down a machine, alert an internal or external group, or log additional information. You can only call a website that begins with https://. You cannot make more than 200 calls per hour or 1000 calls per day. The time zone for midnight is based on the time settings for your Connect subscription.
Note
Only Developer users can specify this process.
Delete Records
Use to delete a record before it goes into the table. This is useful when used with a filter. For example, you can set a filter to delete a record if a specific field comes in blank.
Deduplication
Remove duplicate values. Select whether to merge or remove the duplicates. If you merge them, select how you want to merge the remaning fields. If you remove them, select the criteria used to retain the record.
Specify for Minitab Connect to send an email. Separate multiple email addresses with commas.
Exit
Stop running the flow using a specific criteria. If the criteria is met, the rest of the flow will not run.
From Table and To Table
From Table pulls data from a different table to your active table. To Table pushs data from the active table to a different table. You can insert or update value off of a unique value that you set. For example, if you had two ID fields, you could match the IDs and update values based on those matches.
Notification
Sends a notification to the bell button
in
Minitab Connect.
Slack
If you are integrated with Slack, you can use this to send information to Slack channels.
Refresh SQL Field and Refresh Custom Field
Runs all custom code you have set in fields. Use this feature if you have code in fields that times out or does not run due to some other timing issue. Adding this data process ensures that the fields are up-to-date. You can also use this before an exports to ensure that you export the most current table.
Refresh Table
Refresh a table. This performs the same action as when you select the
refresh button
in the
Prep Tool.
Retry
Set a process that has failed to retry a specified number of times. You can set a maximum number of retry attempts. You can also set the time period that Minitab Connect waits between attempts.
Run Data Process
Run a data process that you have previously saved. You can run it on the active table, or you can select a different table on which to run it.
Run Export
Run an export that you have previously saved. You can run it on the active table, or you can select a different table on which to run it.
Transform
Clean up text values. You can make the text all uppercase, all lowercase, remove special characters, or trim whitespace.
Truncate Table
Resets all of the IDs to 1 and clears out all the information.
Note
Only Developer users and above can specify this process.
Flip Data
Sorts the data in reverse order. The bottom row becomes the top row. The top row becomes the bottom row. And the remaining rows follow the same pattern.
