Complete the following steps to import data from a connection and create a new table in
Connect.
- From the Home screen, select the
Add button under Tables.
- In Datasets, enter Dropbox and
select the connector from the results.
- Under Connection, select the Dropbox
connection that you previously set up. If you have not previously set up a
connection, select New Connection and follow the
steps in the previous section.
- On the left panel, enter a Name that identifies the table
and select a Folder to save the table.
- In File, enter text to filter the list. Then select the files that you want to
import and select Next. If your file is nested in a
folder, select the folder then Next before you select the file.
If your file is nested in multiple folders, repeat this step for each
folder.
- Under Delete Files, select to delete the file from
Dropbox, move it to the Historic folder, or do nothing. If a Historic folder
does not exist, Connect creates one.
- In File Pattern, enter a string to match files for subsequent
imports. Enter a percent symbol (%) before and after the string. For
example, each day you import a file named "Measurements" that also has the
date appended to it. You can enter %Measurements% to
import any file name that has the word "Measurements" regardless of the date
that is appended to it. If you don't enter a string, subsequent imports look
for files that are identical matches to the name of the original import.
- Select Save
. If you go to the
Prep Tool and select Run
, Minitab Connect
displays the imported data. Note
If no data appears
after you select Run, select Reset Config
.
When you save the import, Connect creates a flow with the settings that you selected. For more
information on how to schedule a flow and add more data processes to clean data, go
to Overview of the Flow Tool
.