Decimal number is not reading properly

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

Datasets

Common Use Cases

Transformation

Help

Accepted answers

All comments

IraWatt

Hey @Karlygash,

How are you reading the data into Alteryx? If its a file output can you give an example file?

Thanks,

Ira

Karlygash

Yes, it is an excel file

Book1.xlsx

Karlygash

Hi @IraWatt , yes it is an excel file

Book1.xlsx

IraWatt

@Karlygash looking a the Excel file, its data is different to Athena.

Alteryx is just copying the Excel file.

Karlygash

sorry, uploaded the right one

Output from athena @IraWatt

Digital_FCST (1).xlsx

IraWatt

@Karlygash Strange when I import it into Alteryx the file is the same as your Athena data:

Karlygash

Hi @IraWatt

Can you check fact_tpc_bud tab, please?

IraWatt

@Karlygash It does look like its the download from Athena which is the issue:

The Excel sheet is different to the Athena data and Alteryx is just copying what's on the sheet

Karlygash

@IraWatt can you help me to understand what does download from athena mean?

This files are located in local folder, now i m trying to write them to Athena and having this issue

IraWatt

@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

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

Karlygash

@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

@IraWatt Yes right, it Athena it is showing INcorrectly

tkong

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

Karlygash

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703