Decimal Point added automatically

[RMojsiak]

Hello everybody,

I import multiple xlsx files and for a column, in which I have numbers or letters and digits combinations, sometimes Alteryx will import the number with a decimal point, which isn't in the raw file. For example, in the file, I have 38012011800022200000, but Alteryx imports it as . 

I tried formating the original file in Excel and to use formulas in Alteryx (ToString, ToNumber), but had no luck.

Does anybody else have this problem?

[atcodedog05]

Hi @RMojsiak 

Convert to fixed decimal like.

Workflow:

Hope this helps : )

[RMojsiak]

Forgot to mention, but I tried that and it comes back as NULL (after filtering out all the rows that have letters).

[atcodedog05]

Hi @RMojsiak 

Can you share sample data and tell us what you are trying to do.

Happy to help : )

[RMojsiak]

I need to join these values with a database and take some information from there. Considering that Alteryx is changing the value, I cannot do that...

[atcodedog05]

Hi @RMojsiak 

Try this

Hope this helps : )

[RMojsiak]

It doesn't seem to be the same number as the input one.

38012011800022196224.00000000000000000000

38012011800022200000

I have a different number of digits so I cannot trim it and add the zeroes.