cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Recode - Numeric Transformation

What 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.

 

3 Comments
hogi
Level XII

via 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 

hogi_0-1719418701915.png

selector to Formula editor:
- right click on a column

- select hogi_1-1719418767563.png
- key in the formula

- and select hogi_3-1719418810400.pngfrom the new drop-down menu

and voila : Recode with all the possibilities of Formula editor

 

 

 

hogi
Level XII

Ah, thanks -> already delivered with JMP 18  

hogi_1-1719474123723.png

 

via :

hogi_0-1719474093407.png

Might be triggered by New Formula column - new entry: draft function - but much (!!!) more powerful than requested in that wish.
Wonderful!

 

hogi
Level XII

hi @Sarah-Sylvestre , thanks for delivering this feature. One of THE improvements in JMP18 : )