Import -- Columns

Use the Columns page of the Import notebook to specify column options.

Tasks

• Importing a file to an existing table:
  • Using default settings (method D)
  • Mapping column positions (method P)
  • Mapping data columns by starting and ending column locations (method L)
  • Mapping column names (method N)
• Creating a new table from an input file:
  • Specifying file options when creating a new table or deleting rows in an existing table and repopulating it

Fields and controls

The available controls vary depending on which file type and import mode you selected on the File page.

• Add
• Change
• Column names
• Column position
• Data column
• Move Down
• End position
• Include
• Include columns by
• Index table space
• Long data table space
• Null indicator
• Remove
• Start position
• Table column
• Table name
• Table schema
• Table space
• Move Up
• OK
• Cancel

Related information

• Import -- Overview