Review/Edit Column Types

  1. In the Select Excel Range for the Analysis dialog box, select the Review/Modify column types before importing check box.
  2. Click the OK button to display the Review/Edit Column Types dialog box.

When the Review/Modify column types before importing check box in the Select Excel Range for the Analysis dialog box is cleared, clicking OK closes this dialog box and displays the analysis or graph dialog box specified.

Process to change a column type now:

  1. Select Properties from the File menu to display the Select Excel Range for the Analysis dialog box.
  2. Select the Review/Modify column types before importing check box.
  3. Click OK button to display the Review/Edit Column Types dialog box.
  4. Statistica reviews all the columns being imported, and lists them in the Review/Edit Column Types dialog box along with the type.
  5. To change an assignment, you can select the particular column name and double click it, or select the column name and click the Edit button to display the Change import column type dialog box.
  6. You can select multiple column names using the standard SHIFT+click or CTRL+click commands in order to change more than one column type at the same time.