Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Truncating characters while importing the spread sheet into dataset.

Accepted answer
31
Views
3
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

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:

image.png

Imported dataset

image.png

Best Answer

  • Benjamin Arnulf-Oracle
    Benjamin Arnulf-Oracle Admin
    Answer ✓

    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:

    image.png

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

    image.png

Answers