good to know: - how to do this and that in Jmp? - where Jmp is different from other programs - where Jmp is different from Jmp (inconsistencies) [More Topic Containers like this] Topicadditional infoData Tables Why is it not possible in Jmp: - to define a formula for a specific cell? - to select any 2 cells in a spreadsheet? JMP is Not a Spreadsheet Is there a tutorial how to "slice" matrices? matrix[5::-1]answer NB: The indexing of matrices will be improved in a future version of Jmp why new table()? answer why is there no dt << n rows()?answerWhy does add row add a row to a data table - but doesn't add the values?answerWhy are there different column names for data imported via Open and MFI?answerIs there something in JMP like freeze pane in Excel? lock Columns New Formula Column / Concatenate numeric values New formula column / count strings Graph Builder Why do FitYbyX and GraphBuilder use different color codings? answer When comes (collision free) Column Switcher 2.0? wish: Add new switcher called Role Switcher GUI Why is there no Select mode in the Local Data Filter - like the one from (global) Data Filter?wish: Local Data Filter - don't disable the SELECT option In the Join Tables Platform, what's the difference between Update main table with data from second table and Merge same name columns? The submenus of my Jmp installation open to the left - Where is the setting to move the submenus to the "right"? Why does Scripting Index/See also not list the function xyz ?you want more items to show up in see also ? suggest them here: Scripting Index and online Help: "see also"

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Collection of "funny" Jmp newbie questions

hogi

good to know:

- how to do this and that in Jmp?

- where Jmp is different from other programs

- where Jmp is different from Jmp (inconsistencies)

[More Topic Containers like this]

Topic	additional info
Data Tables
Why is it not possible in Jmp: - to define a formula for a specific cell? - to select any 2 cells in a spreadsheet?	JMP is Not a Spreadsheet
Is there a tutorial how to "slice" matrices? matrix[5::-1]	answer NB: The indexing of matrices will be improved in a future version of Jmp
why new table()?	answer
why is there no dt << n rows()?	answer
Why does add row add a row to a data table - but doesn't add the values?	answer
Why are there different column names for data imported via Open and MFI?	answer
Is there something in JMP like freeze pane* in Excel?*	lock Columns
New Formula Column / Concatenate numeric values
New formula column / count strings

Graph Builder
Why do FitYbyX and GraphBuilder use different color codings?	answer
When comes (collision free) Column Switcher 2.0?	wish: Add new switcher called Role Switcher
GUI
Why is there no Select* mode in the Local Data Filter - like the one from (global) Data Filter?*	wish: Local Data Filter - don't disable the SELECT option
In the Join Tables Platform, what's the difference between Update main table with data from second table and Merge same name columns?
The submenus of my Jmp installation open to the left - Where is the setting to move the submenus to the "right"?
Why does Scripting Index/See also not list the function xyz ?	you want more items to show up in see also ? suggest them here: Scripting Index and online Help: "see also"

Accepted answers

jthi

Lock Columns (jmp.com) might work

All comments

hogi

Is there a tutorial how to "slice" matrices?
I just found infos like this one
https://www.jmp.com/support/help/en/16.2/?os=win&source=application#page/jmp/subscripts-2.shtml
with some basic indexing like

mat[from::to, from2::to2]

Is indexing also possible "relative to the end" (minus sign doesn't work) or indexing with open start or end (leaving the slot empty doesn't work)?

mat[1::-1];<BR /><BR />mat[1::];<BR /><BR />mat[::]

edit: wish
https://community.jmp.com/t5/JMP-Wish-List/new-slicing-options-for-matrices/idi-p/559090#M2563

hogi

why is it

current data table()
data table("my name")

but

new table()

(without "data") - because there is no data yet in the table?

Here it seems that "tables" and "data tables" are something similar, but this is definitely not true:
https://community.jmp.com/t5/Discussions/Collection-of-quot-funny-quot-JSL-newbie-questions/m-p/559063/highlight/true#M77234

hogi

why are there so many messages that I can send to a data table but not

dt << n rows()

just working:

n rows (dt)

edit: wish
https://community.jmp.com/t5/JMP-Wish-List/lt-lt-n-rows-to-get-the-rows-of-a-data-table/idi-p/559101

hogi

Why does add row add a row to a data table - but doesn't add the values *)?

*) adding values with the same syntax just works for Table Boxes

dt = New Table( "Untitled" );
dt << add row( {1} );

New Window( "test",
	tb = Table Box( String Col Box( "string col", {"a"} ), 
	Number Col Box( "number col", {1} ) )
);
tb << add row( {"b", 2} );

edited: wish to provide a shortcut function like add row(list of values) also for data tables
(very convenient for data collection in for loops - e.g. for debugging)
https://community.jmp.com/t5/JMP-Wish-List/easy-way-to-add-rows-amp-values-to-a-data-table/idi-p/559082

jthi

Is there a tutorial how to "slice" matrices?

What is the JSL Matrix?
Try using 0

Names Default To Here(1);

m = J(2,5,1);
Show(m[1,0]);
Show(m[0,1]);
Show(m[0,0]);

why are there so many messages that I can send to a data table but not
- Data table object doesn't seem to have N Rows. N Rows is a different function which can be used on different objects
Why does add row add a row to a data table - but not the values?
- Add Row does work (no idea why...) but you have to use different syntax when adding values (see Add Rows).
- ```
Names Default To Here(1);

dt = New Table( "Untitled" );
dt << Add Row({"Column 1"n = 1});
dt << Add Rows({"Column 1"n = 2});
```

txnelson

It is a simple matter to slice matrices

names default to here(1);

mat = [10 20 30 40 50, 15 25 35 45 55];
show( mat[1,0]);
show( mat[1,2::4]);
/*:

mat[1,0] = [10 20 30 40 50];
mat[1,Index(2, 4)] = [20 30 40];

txnelson

I don't understand your

current data table()
data table("my name")

issue.

txnelson

This is an example of one of the inconsistences in JSL. Not all functions have a message equivalence. I suggest that when you come across an inconsistency that you add a request to the JMP Wish List to resolve the inconsistancy

hogi

Workaround for add row(with values):
collect the info in a Table Box, then use

and copy the data to a data table.

Mark_Bailey

A function is a subroutine that you can call anywhere in a script. It might take one or more arguments. It returns a value. It might have a side effect, like instantiating a display box.

A message invokes a method implemented by an object.

It doesn't make sense (to me) to necessarily have a message to duplicate every function if that is what you are suggesting. What additional benefit does the message, dt << N Row, provide that you cannot get from the function call, N Row( dt )?

You must learn the syntax, keywords, functions, and protocols for any computer language.

hogi

I edited the original text to make it clearer.
I wondered why it is not</CODE></P><PRE><CODE class=" language-jsl">new <STRONG>data</STRONG> table()

hogi

Hi,

in the Scripting Index, there is a button "see also" which suggests the interested user alternative functions in the context of an initial found function.

Unfortunalely, there are some "links" missing between the entries. e.g.

get <-> set clipboard

N Args <-> Head

I posted a "container" wish to collect such missing links such that they can be added:
Scripting Index and online Help: "see also"

Did it happen to you as well that you search a function in the Scripting Index for some while and found out that you cannot find the right term to search it?
If you found the correct function afterwards by luck, could you please add a screenshot to the "container" wish to help other users to find the function faster ...

... and support the idea with a Kudo : )

hogi

Why is there no Select mode in the Local Data Filter - like the one from (global) Data Filter?

vs.