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
Solved! Go to Solution.
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
I think I figured out my own question. To merge the data so the fractions are converted to decimals within the same field. I used the If statement:
IF Contains([1st End Nom. Thread Size], '/') THEN
tonumber([fraction1]) / tonumber([fraction2])
ELSE [1st End Nom. Thread Size]
ENDIF
Well done.
Its only the beginning. It get better 🙂