nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Truncating characters while importing the spread sheet into dataset.

Rajakumar Burra

I have a spreadsheet where one column is having numbers and alphabets as values.

When importing , it is truncating the values. Is it known issue?

Workaround:

Modify the data to have more characters than number characters. Example: "na" should be replaced by "naaaa"

30229dde-1764-4295-b1cf-2c4a220c0f03.xlsx

Data:

Imported dataset

Find more posts tagged with

Accepted answers

Benjamin Arnulf-Oracle

Hi Rajakumar, I test on my side. It seems. you have a custom format applied to the column and saved in the XLSX. This is causing characters being truncated:

I saved the file in CSV to remove the formatting and it's working normally as expected:

All comments

Benjamin Arnulf-Oracle

Hi Rajakumar, I test on my side. It seems. you have a custom format applied to the column and saved in the XLSX. This is causing characters being truncated:

I saved the file in CSV to remove the formatting and it's working normally as expected:

Benjamin Arnulf-Oracle

+ @Bret Grinslade - Oracle Analytics-Oracle and @Luis E. Rivas -Oracle for awareness

Rajakumar Burra

Thanks @Benjamin Arnulf-Oracle .