When you edit settings on a selected file in the Import Data page, the following settings are displayed.


You can edit any additional or optional settings for an individual dataset. Perform the following:

  1. Click Edit Settings from the card for an individual dataset in the right panel. The dialog box is displayed. 
  2. In the dialog box, select the required options and modify the settings.

Per-file encoding

By default,  applies a specified encoding type on the imported the file. In some cases, the data preview panel may contain garbled data, due to a mismatch in encodings. In the Data Preview dialog, you can select a different encoding for the file. When the correct encoding is selected, the preview displays the data as expected. 

NOTE: Assessing the file encoding type based on parsing an input file is not an accurate method. Instead, assumes that the file is encoded in the default encoding. If it is not, you should change the encoding type for the file.


NOTE: In some cases, imported files are not properly parsed due to issues with encryption types or encryption keys in the source datastore. For more information, please contact your datastore administrator.

For a list of supported encoding types, see Supported File Encoding Types.

For more information on supported encodings, see Configure Global File Encoding Type.

Detect structure

By default,  attempts to interpret the structure of your data during import. This structuring attempts to apply an initial tabular structure to the dataset.

Remove special characters from column names

When selected, characters that are not alphanumeric or underscores are stripped, and space characters are converted to underscores.

Tip: This feature matches the column renaming behavior in Release 5.0 and earlier.

For more information, see Sanitize Column Names.

Selecting column headers

You can apply the column headers to your datasets during import. Select the required option from the drop-down list:

If replacing a file: 

Tip: After the dataset is imported, you can rename columns manually or using any row in the dataset. For more information, see Rename Columns.