cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

Row column

What is the fastest way to get a column

New Column( "Row",	Formula( Row() ))

1 click = 1 drag&drop = 1 key pressed

4 REPLIES 4
jthi
Super User

Re: Row cloumn

Toolbar/add-in/script with such a functionality. Or you can create initialized column after right clicking on the column header

jthi_0-1675070378953.png

 

Edit:

If formula is needed New Formula Column context menu should be able to do it

jthi_0-1675072779205.png

 

 

-Jarmo
hogi
Level XII

Re: Row cloumn

wow, initialized values - very useful!
always something new to learn

 

The approach via the  right click new formula column menu is nice - 4 "clicks" (or mouse movements without clicking).

let's see if anyone can beat that.

 

By the way, there is no shortcut formula to count the entries in a column, e.g. the :name column, right?

New Column( "count",Numeric,"Continuous",	Formula( Col Number( 1, :name ) ));

 

jthi
Super User

Re: Row cloumn

Seems like Character columns won't let you use Count which would do this when used with Group

jthi_1-1675084927440.png

jthi_2-1675084935798.png

jthi_4-1675085070576.png

 

 

 

-Jarmo
hogi
Level XII

Re: Row cloumn

strange, isn't it?