This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.
I am seeking few expert advise as I am stuck with my tool. My raw data has a specific column of references which includes Alpha Numeric as well as pure numeric references and these references are pretty huge like 22 characters. Currently my column is V WString so Alteryx is converting all Alpha numeric references perfectly but all my pure numeric references are getting converted to scientific E Notations. eg: 1.01000028133037E+18.
I want all these references to be readable as a whole and not scientific notation. I tried converting my column into a numeric field but that is affecting my Alpha Numeric references. Is there a way where alteryx will be able to read the column pure numeric values as is without converting them to scientific notation.
@atcodedog05 -Thanks a lot for ur response, Would you be able attach your workflow just want to refer it.
Also if I split the values and apply the formula, will it apply to all the values in columns or will it only apply to values which are converted to scientific notations. Because I don't want to touch the alpha numeric values as they are perfect as of now.
I want to share a sample with you just to clarify if this is how it works. I am reconciling 2 files, in one of the input files the value is ABC202008200201471060826 and othe input file has the values as split ABC (in 1 column) and 202008200201471000000 (In column 2) which I converted from scientific notation to standard . so when I concatenate the values from 2nd input file I get value as ABC202008200201471000000 which will never match with file 1.
My question here is zeroes which are added post conversion in 2nd file (202008200201471000000) is it bcz the original input file doesn't have the full value or is it that our conversion formula is incorrect. Because as I stated the actual reference value should be 202008200201471060826 .
Just want to understand this logic of scientific notation, ur solution is perfect otherwise.