Dataiku doesn't recognize Excel General format correctly

annabekesi
annabekesi Registered Posts: 1 ✭✭✭

Hi,

I'm uploading Excel sheets to Dataiku and all my fields are in the General format. The dataset is formatted as a table.

When I'm uploading it to dataiku all the data is set as string however there are suggestion of what the correct datatype should be (decimal, integer, date etc).

I tried:

- changing the data format in Excel--> dataiku still doesn't recognize them as the correct datatype

. manually setting the datatype in Dataiku (works there but when I export to Redshift and try to use the dataset in tableau it still doesn't recognize date as a date (it is set as string)

Is there any way to make Dataiku recognize data properly?


Operating system used: Windows 10

Answers

Setup Info
    Tags
      Help me…