Hello,
I have both decimal values and Fraction values within a "Nominal Size" field.
How do I convert the all the fractions within the field to decimals so I can set the field as a Double Variable? Simply 3/4 to 0.75
Thank you,
Tommy
You could split the number by forward slash using Text-to-Columns > then convert the numbers to integers > then calculate the quotient in a formula tool.
Example attached,
Hello @Tommy1 ,
Alteryx can do it for you. Is there a specific scenario you have .
Check attached.
Worked a treat! thank you for the quick response.
I also had some "#N/A" and "N/A" data within that column which I'll remove with a formula.
However, How do I now merge the newly created "decimal" field and the original "nominal size" field.
Basic question, I only started Alteryx yesterday
Thank you
