Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Workbooks can be uploaded from your local system. 
If

D s product
is connected to a backend file storage system, you can also import workbooks stored in readable directories.

Limitations:

  • Filepath and source row number information is not available from original Excel files. These references return values from the CSV files that have been converted on the backend. For more information, see Source Metadata References.
  • Source Excel files with cells bracketed by single double quotes may not be properly ingested if any terminating quotes are missing.

    Tip

    Tip: You can check the data quality bars for mismatched values or, for strings, the data histogram bars for anomalous values to see if the above issue is present. If so, deselect Detect Structure on import. Then, use a Split rows transformation applied to the affected column to break up the column as needed.


  • You cannot import password-protected Excel files.
  • Compressed Excel files are not supported.
  • Conversion of large Excel files require non-linear increases in memory requirements on the
    D s node
    .

...