Decimal number is not reading properly

[Karlygash]

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 

[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

[Karlygash]

Hi @IraWatt , yes it is an excel file

[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 

[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