Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

Dataiku doesn't recognize Excel General format correctly

annabekesi
Level 1
Dataiku doesn't recognize Excel General format correctly

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

0 Kudos
2 Replies
CoreyS
Community Manager
Community Manager

Hi @annabekesi welcome to the Dataiku Community and thank you for your question. While you wait for a more detailed response, I wanted to provide you with some resources.

You may have already found these, but if not, I hope this helps!

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos
Manuel
Dataiker
Dataiker

Hi,

From your description it is unclear what exact problem you are facing. Perhaps you can add an example.

Your text seems to imply you know this already, but just to be certain: when you are uploading the file, you can navigate to the schema tab and manually set the column types.

On dates, if the source column uses a non-ISO-8601 or non-RFC-822 format, it needs to be converted to a standard non-ambiguous format after you upload. For this, you use the Parse Date processor in a Prepare recipe. This should fix any problems handling the date downstream. Check this page for more information.

I hope this helps.

0 Kudos