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

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 .