Import Lookup Table Data

Use this window to specify in detail what data you want to import from a specific file into the current IBM® Cognos Controller lookup table. This window cannot be selected directly, it is a sub window to the Edit Lookup Table window.

Procedure

  1. On the Transfer menu, click External Data/Edit Lookup Table. The Edit Lookup Tables window opens or click the Details button and then click the Import button to open the window Import Lookup Table Data.
  2. Enter the path and the name of the file you want to import data from or click the Show Valid Choices button and select the file.
  3. Select one of the alternative buttons Fixed format file or Delimited file to specify the format of the import file.
  4. If you selected Delimited File, enter the type of separator that is used in the file.
  5. Go through the fields one by one and select what information should be imported to each field from the window. You should only select information from the first row to be imported.
  6. Select the Append Data to the Lookup Table if you want the data to be appended to the lookup table. This means that the original data in the lookup table is kept and the new data is added at the end of the table. If you do not select this check box the original data in the lookup table will be overwritten when you save.
  7. Click OK to import data and to go back to the Edit Lookup Table window.