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

Indicator Symbol for Columns used in Formulas + batch replace

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☑ nice to have

☐ nobody needs it

 

What inspired this wish list request? 

I want to clean up a data table with a few hundred columns.

A few columns are used in formulas and have to be replaced by new columns. The remaining columns can be deleted.

When deleting the old columns, it is difficult to identify the columns which are used in column formulas.

 

What is the improvement you would like to see? 

1) Please display a symbol next to columns that are used in Formulas.

 

2) Please provide a functionality to generate a formula lookup map.

a) The map should list all formula columns with the columns used in the respective formula.

b) In addition the Window should provide a list of all columns which are used in any Formula column.

 

e.g. 

 

ratio = height / weight

myequation= (height - weight)^sex

 

a)

- ratio: height, weight

- myequation: height, weight , sex

 

b) 

- height

- weight

- sex

 

Part a) is useful to get an overview and to work on specific formulas, 

Part b) is useful for batch-replace: 

A right click menu should be available which allows to replace the specific column in ALL column formulas with a replacement column.

 

Why is this idea important? 

Will help to edit column formulas after changes of the input column names.

 

more wishes by  hogi_2-1702196401638.png

4 Comments
SamGardner
Staff
Status changed to: New

Have you tried the Formula Depot (Analyze>Predictive Modeling>Formula Depot)

SamGardner_0-1706724425984.png

 

hogi
Level XII

for formula columns?

hogi
Level XII

This Script collects all Columns which are used in formulas and displays an overview:

https://community.jmp.com/t5/Discussions/Can-you-search-column-formulas/m-p/776949/highlight/true#M9...