We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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