Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Decimal Point added automatically

RMojsiak
8 - Asteroid

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 RMojsiak_0-1643961614968.png

 

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?

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @RMojsiak 

 

Convert to fixed decimal like.

 

Workflow:

atcodedog05_0-1643962010740.png

 

Hope this helps : )

 

RMojsiak
8 - Asteroid

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

atcodedog05
22 - Nova
22 - Nova

Hi @RMojsiak 

 

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

 

Happy to help : )

RMojsiak
8 - Asteroid

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
22 - Nova
22 - Nova

Hi @RMojsiak 

 

Try this

 

atcodedog05_0-1643963881505.png

 

Hope this helps : )

 

RMojsiak
8 - Asteroid

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.

Labels