Converting a string field into a numeric field that contains non numeric characters in Alteryx
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2021
- In this video I will show how to convert numbers that contains non-numeric characters. For example, if -100 is presented as (100) Alteryx does not recognize this as a negative number and we need to remove the parenthesis and add a negative symbol.
Good one bro, but how to change positive number to negative, please help
What about multiple fields in one go
In this instance you can use the Multi Field Formula Tool. With this tool you will do the same formula but instead of selecting one field to alter you can select many.