Processing Format Conversion Errors when Uploading Data


When uploading data from a delimited or Excel file, a format conversion error can occur, such as when a numeric field contains a non-numeric value. You have load options to control how to process rows that contain format errors, and to control how many format errors are allowed before processing stops.

The following conversion error load options are available when uploading files:

  • Conversion error processing.

    You can select options Reject or Ignore. Reject, the default value, skips rows with incorrect data, and gives a warning message. Ignore replaces the values causing errors with default values, and continues processing the records.

  • Conversion error limit.

    You can enter values of 0 to 999999. This sets a limit for the number of records allowed with warnings about data conversion errors. 0 is the default value, which allows unlimited warning messages.

These load options are available when uploading files in the Simple Mode or the Advanced Mode.

Procedure: How to Process Format Conversion Errors in Simple Mode

  1. Upload an Excel or delimited file using Get Data. For more information, see the Uploading Data Files topic in the WebFOCUS KnowledgeBase.

    The Uploading Data page opens, as shown in the following image.

  2. Click More.

    The More File Options dialog box opens. Under Source Load Options, the conversion error options display, as shown in the following image.

    You can select Reject or Ignore from the Conversion error processing dropdown menu. You can also enter a value in the Conversion error limit field.

  3. Click Save and Redo Prepare to save your changes.

Procedure: How to Process Format Conversion Errors in Advanced Mode

  1. Upload an Excel or delimited file using Get Data. For more information, see the Using the Get Data Advanced Mode topic in the WebFOCUS KnowledgeBase.

    The Uploading Data page opens, as shown in the following image.

  2. Click the Advanced Options vertical ellipsis.
  3. From the menu, select Load Options.

    The Load Options dialog box opens. Under Source Load Options, the conversion error options display, as shown in the following image.

    You can select Reject or Ignore from the Conversion error processing dropdown menu. You can also enter a value in the Conversion error limit field.

  4. Click OK to save your changes.