The table below compares the file import experience across three tools—Platform UI, New Datasets UI, and Designer Input Tool—highlighting their key differences and use cases.
Scenario | File Type | Platform UI | New Dataset UI | Input Tool |
|---|---|---|---|---|
Preview Row Count | CSV | Preview shows max 20000 rows. | Preview shows max 20 rows. | Preview shows max 10 rows. |
Excel | Preview shows max 6 rows per sheet. | Preview shows max 20 rows per sheet. | Preview shows max 1000 rows. | |
Data Type Inference | All | Column data types are same in preview while and after creating dataset. Types are inferred. | Data types are shown as String while creating dataset and inferred after creating the dataset. | Preview does not show any data types at all. There is a checkbox in input tool which controls type inferencing after dataset is created. |
Supported Dataset Options | CSV | Encoding | Encoding | Encoding |
Header - First row - No header - Infer header | Header - First row - No header - Infer header | Header - First row - No header - Infer header | ||
Detect structure | - | - | ||
Remove special characters from column name | - | Sanitize Column Names | ||
- | Quote char | - | ||
- | Column delimiter | Column delimiter | ||
- | Row delimiter | New Line Character | ||
Excel | Header - First row - No header - Infer header | Header - First row - No header - Infer header | Header - First row - No header | |
Remove special characters from column name. | - | - | ||
- | Import Raw Data. (Disabled by default) | Import Raw Data. (Enabled by default) | ||
Dataset Creation - All sheets in one dataset - Selected sheets in one dataset - One dataset per sheet | Dataset Creation - All Sheets - Selected Sheets | Dataset Creation -Selected Sheet (select 1 sheet only) | ||
- | - | Start Data Import on Line | ||
TXT JSON PQT XML | Dataset options and preview supported. | Dataset options and preview are not supported. | Only CSV and Excel can be uploaded on Input tool. | |
First Few Empty Rows | Excel | Empty rows are skipped and we start reading from first non empty row. | Empty rows are not skipped. | Empty rows are skipped and reading starts from first non empty row. |
Parameterization | Support Excel parameterization. | Support Excel parameterization. | Not Supported | |
Multiple File Upload | All | Supported | Not Supported | Not Supported |
Dataset Creation Experience | Excel | User is expected to manually refresh the page after dataset is created to see schema and preview. Otherwise there is no indication that the job is complete or dataset is usable. | Conversion job runs before user can create the dataset. | User is shown the message in UI. If conversion job fails, Dataset is not created. |
A File Without Extension | Error is shown and dataset is not created. | User is able to upload any corrupt file and a dataset is created | Error is shown and dataset is not created |