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.
@atcodedog05 I need to take this one step further, apparently I did not know that there were also alpha characters in this field, the test file I used probably didn't have this condition. What function could I use to fix both of these situations?? Thanks!!
@atcodedog05 The expected output is what I've shown above, the notation I'm seeing in the field with the xxxxxxxxxE+11 type format is showing up so that prevents me from seeing the entire account number.
I want the field to end up being a string field that I can query against. I'm trying not to go into each file and change the field type manually which I know would correct the issue. I'm also new to Alteryx and trying to solve with some functions to enhance learning.
@atcodedog05 Something is still not right - see error messages. My data coming in from the source is shown below. The Input Data tool is brining this field in as Double. I'm using a select tool to change the type to V_String which is generating the error messages shown. When I use the formula you supplied I'm getting the Parse error; tried to apply a string operator to numeric value. I think I've totally confused the situation.....