cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
%3CLINGO-SUB%20id%3D%22lingo-sub-594735%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EColonne%20de%20ligne%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-594735%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EQuel%20est%20le%20moyen%20le%20plus%20rapide%20d'obtenir%20une%20colonne%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENew%20Column(%20%22Row%22%2C%20Formula(%20Row()%20))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E1%20clic%20%3D%201%20drag%26amp%3Bdrop%20%3D%201%20touche%20enfonc%C3%A9e%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-594735%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3ETableau%20de%20donn%C3%A9es%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-594781%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%26nbsp%3B%3A%26nbsp%3BNiveau%20de%20ligne%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-594781%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EBarre%20d'outils%2Fcompl%C3%A9ment%2Fscript%20avec%20une%20telle%20fonctionnalit%C3%A9.%20Ou%20vous%20pouvez%20cr%C3%A9er%20une%20colonne%20initialis%C3%A9e%20apr%C3%A8s%20un%20clic%20droit%20sur%20l'en-t%C3%AAte%20de%20la%20colonne%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1675070378953.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1675070378953.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1675070378953.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F49605iF54A1AD1B25B7650%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1675070378953.png%22%20alt%3D%22jthi_0-1675070378953.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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?

Recommended Articles