Complete the following steps to import data from Mongo and create a new table in Connect.
- From the Home screen, select the
Add button under Tables.
- In Datasets, enter Mongo and
select the connector from the results.
- Under Connection, select the Mongo 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.
- Select the Collection that contains the data. Then
select Next.
- In Fields, enter text to filter the list. Then select the table fields that you
want to import and select Next.
- Select Add Filter and select the field you
want to filter. Next, define the filter. Select an expression and a value.
For example, suppose you want a list of documents where the
meta field contains the text "abc". Use the
expression, meta, Contains,
abc. Select the
button on the last
selection box to open the SQL dialog box for more complicated filters. Note
The Mongo connector can only filter top level
properties.
- 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
.