Specifying how to load IXF data into the table columns

Use the Columns page of the Load notebook to specify how to load the columns in the IXF data file.

Fields and controls

To specify how to load the IXF data file columns into the table columns:

1. Open the Columns page of the Load notebook.

2. Optional: Change the default method by which the data file columns are loaded into the table. When you use the default method, the data in the first file column is loaded in the first table column, and so on.

   You might want to change the default method to:

   • Exclude a table column from being loaded with data
   • Load data using data column names
   • Load data using data column position numbers

   To change the default method:

   1. Select the Include columns by check box.

   2. Specify the method by which all data file columns will be loaded into the table by selecting either theColumn names (method N) or Column numbers (method P) radio button.

   3. Select a table column and select the Change push button to open the Change window so you can exclude the table column from being loaded with data or specify the data column name or data column position.

   4. Repeat step c for each table column for which you want to change default values.

3. If you have specified all required information for the load process, you can start the load process now by clicking on OK. Otherwise, to specify required or optional information, or to change default values, go to one of the other notebook pages.

Related information

• Loading data into a table