Create Data Source Containing Text

tell me more icon Tell me more

This cue card set uses the connection and project created in Getting Started with Data Miner.

  1. Follow these steps to create a new workflow named TextMining:

    1. In the Data Miner navigator, expand dmConnection.
    2. Right-click the project HighValue; select New Workflow.
    3. Name the new workflow TextMining.

  2. If the Component Palette is not open, open it using View > Component Palette. Make sure that Workflow Editor is selected.

  3. Create a data source node:

    1. In the Component Palette, click the Data section, and left-click Data Source.
    2. Move the mouse to the place in the workflow identify where you want to place the node. Click.
    3. The Define Data Source wizard is launched.
    4. In the Available Tables/Views list, select the view MINING_DATA_TEXT_BUILD_V. The columns (attributes) of the view are displayed.
    5. Click Finish to select this view with all of the columns selected.
    6. The new node is created. The default name of the node is MINING_DATA_TEXT_BUILD_V, the name of the table.

  4. MINING_DATA_TEXT_BUILD_V contains the column COMMENTS, which contains customer comments. To view some of the comments, right-click the data source node and select View Data. Actual data is displayed in a new tab MINING_DATA_TEXT_BUILD_V. When you are done looking at the data, close the tab.

The text column must be properly prepared before mining.

tell me more icon Tell me more about what I see in the GUI

The cue cards icon Next step is to prepare the text column before you build models.