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%3Ecolumna%20fila%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-594735%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%C2%BFCu%C3%A1l%20es%20la%20forma%20m%C3%A1s%20r%C3%A1pida%20de%20obtener%20una%20columna%3F%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%20arrastrar%20y%20soltar%20%3D%201%20tecla%20presionada%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%3ETabla%20de%20datos%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%3A%20Fila%20columna%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-594781%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EBarra%20de%20herramientas%2Fcomplemento%2Fsecuencia%20de%20comandos%20con%20dicha%20funcionalidad.%20O%20puede%20crear%20una%20columna%20inicializada%20despu%C3%A9s%20de%20hacer%20clic%20derecho%20en%20el%20encabezado%20de%20la%20columna%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