Preparing data files

Data files may require some preparation before uploading them to Data Preparation. This preparation improves automatic data profiling. For details, see About data profiling.

To prepare your data file for use within Data Preparation, verify the following:

  • The first row has only the column header names.

  • The column names include only characters (a-z, lower- or uppercase), numbers (0-9), and underscore (_).

  • The file does not have empty columns or rows.

  • The file does not have any informational header and footer rows (for example, row counts, page number, run date).

  • The Excel sheet does not include objects, such as maps or charts.

  • The file does not have the pivot table format, which is not supported.

  • The dates in the Date and DateTime columns are in one of the following (or similar) calendar formats: MM/DD/YYYY, MM/DD/YY, or Mon DD, YYYY.

    If the dates in these columns are in other formats (for example, the Julian format or the General format used in Excel), convert them to a calendar format.