Preparing data files

Data files may require some preparation before uploading them for a dataset creation. This preparation improves automatic data profiling. For details, see About data profiling.

To prepare your data file for use in a dataset, 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.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.