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 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?
Could you try uploading it as text data then converting it in Athena?
@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
@IraWatt Yes right, it Athena it is showing INcorrectly
mabye show examples of valid inputs to Athena and have alteryx mimic the format of those inputs?
@tkong hi, output should be like in excel file. If i understood u correctly