Recode - Numeric TransformationWhat inspired this wish list request? This is a feature I use all the time in Excel when I need to apply a constant transformation to a set of values
What is the improvement you would like to see? Please consider adding an option under the red triangle menu in the Recode utility for transforming numeric values. Perhaps I need to multiply or divide a few values by 100 because some people input a percent as 0.1 and others as 10. Currently I have to change each of those values one by one but this is very easy to do in Excel as shown by the attached screenshot.
Why is this idea important? Recode is an amazing utility but this seems like a minor gap in its functionality compared to Excel. There aren't many options for recoding numeric column so this would be helpful. The quick New Formula Column options are great for when you need to transform an entire column but often I only need to do this for a few values.
Data Blending and CleanupRe: Recode - Numeric Transformationvia scripting this could be implemented quite easily via col << set each value(f(col))
So, a quite low hanging fruit to add some numeric transformations [maybe those from New formula column?] to Recode - or even more useful:
add a

selector to Formula editor:
- right click on a column
- select 
- key in the formula
- and select
from the new drop-down menu
and voila : Recode with all the possibilities of Formula editor
Re: Recode - Numeric TransformationAh, thanks -> already delivered with JMP 18

via :

Might be triggered by New Formula column - new entry: draft function - but much (!!!) more powerful than requested in that wish.
Wonderful!
Re: Recode - Numeric Transformationhi @Sarah-Sylvestre , thanks for delivering this feature. One of THE improvements in JMP18 : )
Re: Recode - Numeric Transformation@Sarah-Sylvestre
Re: Recode - Numeric Transformationhi @Sarah-Sylvestre
Re: Recode - Numeric Transformation - Status changed to: DeliveredHello, I am marking this as delivered due to functionality in JMP 18, which Hogi posted about in this thread. @J_Reese Please let me know if this functionality does not satisfy your request and we can reopen this wish. Thank you!