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.
We have several records that contain field data of "30E33" that when uploaded will changes into "3.00E+34". I need to find a Cleansing Tool that will recognize the error and correct during my workflow. Please Note: I am not at liberty to change the offending data prior to upload.
Currently I manually change the data for all my reports but would love to find a tool that can help.
Sample data attached. Yes I need to keep the examples as text, and not the automated excel error result. I know what excel is doing, but I want to clean the data prior to input into my workflow process as I cannot change Location text.
There is no need for that. You can change the workflow format temporarily to xml and change the first or second line where it says the alteryx version. You can insert yours or lower. Then change it back to yxmd