Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Decimal number is not reading properly

Karlygash
7 - Meteor

Hi Alteryx users)

 

I am new in Alteryx, currently reading data from the file 

 

So What I have faced for now, my data is not reading correctly.

I am writing these data for AWS Athena, as u can see from the screen shot it cannot read numbers. The first screen from Athena, second one from Alteryx. I set fixed decimal as a datatype with maximum size, but it still the same 

 

Karlygash_1-1654592579836.png

 

 

Karlygash_0-1654592540229.png

 

15 REPLIES 15
IraWatt
17 - Castor
17 - Castor

@Karlygash Sorry I miss read your earlier reply. So what's happening is you read this Excel file into Alteryx then export it to Athena and its appearing wrong?

IraWatt
17 - Castor
17 - Castor

Could you try uploading it as text data then converting it in Athena? 

Karlygash
7 - Meteor

@IraWatt Yes I tried, i uploaded as a string and then converted to decimal. Unfortuantely it is same, also one interesting thing when i convert to int64 it works fine

 

Karlygash
7 - Meteor

@IraWatt Yes right, it Athena it is showing INcorrectly 

tkong
7 - Meteor

mabye show examples of valid inputs to Athena and have alteryx mimic the format of those inputs?

Karlygash
7 - Meteor

@tkong hi, output should be like in excel file. If i understood u correctly 

 

Labels
Top Solution Authors