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.
I have a formula in my workflow that changes from number to string (i believe), this happens when in my "mobility" column does not contain any data. In this case I have to remove the IsNumber() formula from the expression editor and when there is data I have to put it back in. Is there a way to automate this?
I meet the same issue when I input excel file when one or more expected numerical contains an empty or null value in the original excel file. What I am adjustment is to use a selection tool to hardcode if only one or two-column needs to change or use multiple file tools. It has an option to change the data type of multiple fields or dynamic fields. Or you can use tonumber in expression to change the field data type.