Input Tool adding additional decimals to .xlsx file

When I import the attached .xlsx file I get two different values if the column starts with a string or number. I need for the input to show below. Is there a way to get Alteryx to bring in it all as string and not get all of the additional decimal places?

String and Double

String

10200.2

String and Double test.xlsx

Input

Accepted answers

Matt_Kerr

I was able to resolve it with the following formula:

if REGEX_Match([String and Double],"\d+\.\d+")
then tonumber([String and Double])
else [String and Double]
endif

Thanks,

All comments

DiganP

@Matt_Kerr You want to use this function in the formula tool. Make sure the data type is double.

ToNumber([String and Double]).

This will give you the numbers as a double while turning text into 0. Is this what you were looking for?

Matt_Kerr

@DiganP Unfortunately not. I need it to show the string for the first row, then 10200.2 for the 2nd row.

BrandonB

@aeking numbers by definition cannot have leading zeroes and trailing zeroes are additional precision placeholders. If you need these leading and trailing zeroes you should likely keep your values as strings rather than converting to numbers.

vaughangary

What about 03 as text into Excel? If you type it directly into Excel, it is '03 (showing as 03). From alteryx, i only get 03 from 03 or '03 from '03. Neither replicate the Excel scenario where '03 shows as 03.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235