Data format Issue - (Excel to Alteryx)

rahulshetty925

Hi All,

Alteryx is pulling records from excel in a strange way.Wanted to know if anyone has faced this issue before.

The goal is to pull the column as it is, as the column has string and numbers.

The second and third rows are the issue here.I can resolve this by selecting an integer data type, but I have characters too in the source.

Source (excel file) column A                             Output - (Alteryx)

1.14                                                                             1.14

1.13                                                                             1.1299999999999999

0.28                                                                              0.28000000000000003

0.28 abc +0.29 def                                                       0.28 abc +0.29 def

Let me know if anyone has seen this issue before and has ways to tackle this.

Thanks,

Rahul 

Tyro_abc

Hi Rahul

I think this is happening when you have mixed data in your spreadsheet, excel is converting data internally in some other format.  If you only have numbers, you won't face this problem ( at least in my machine, I am not facing that issue when only numbers are present).  But for your data, I used an excel function to convert it to text and that seems to be working. Can you please try the same and share the result? Once you apply the formula, values would be left-justified

This is output after loading these two columns to Alteryx

Thanks and Regards

Arundhuti