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%3EZeile%20Spalte%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-594735%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EWie%20kommt%20man%20am%20schnellsten%20an%20eine%20Spalte%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%20Klick%20%3D%201%20Drag%26amp%3BDrop%20%3D%201%20Taste%20gedr%C3%BCckt%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%3EDatentabelle%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%3EBetreff%3A%20Zeile%20Spalte%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-594781%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESymbolleiste%2FAdd-In%2FSkript%20mit%20einer%20solchen%20Funktionalit%C3%A4t.%20Oder%20Sie%20k%C3%B6nnen%20eine%20initialisierte%20Spalte%20erstellen%2C%20nachdem%20Sie%20mit%20der%20rechten%20Maustaste%20auf%20die%20Spalten%C3%BCberschrift%20geklickt%20haben%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