This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
...mp/stack-columns-in-data-tables.shtml
Q: With Concatenate, do you not risk duplication of data and how would minimize this?
A: You can use Rows>Rows Selection>Duplicate Rows if you s...
Preparing Data 2024.pptx (402 KB)
June Measurement Data.jmp (5 KB)
Final Dataset-Preparing Data 2024.jmp (9 KB)
...e can understand why the number of rows, or column names, are different.
A: One way is to compare tables using Tables > Compare DataTables.
Q: How would I find specific data like all c...
...ike (it contains hundreds of such structures). "Multi-row uninterested info" represents those useless rows that I don't want to import. Besides copy and paste the I/V/R data portion, I also like to e...
...ptionally, its subfolders as well) into a single .jmp table.
Concatenate a table with itself any number of times.
Sample tablerows with or without replacement.
Convert between multiple-r...
Date Format Column Creator Instructions.docx (5,075 KB)
DataTable Tools.jmpaddin (45 KB)
...ou will see the number of observations in each categorical level.
Q: Can we group scripts on JMP datatable for common categories?
A: Yes. Select the scripts you wish to group, right c...
Mastering Visualize and Explore 2024_Feb.pdf (542 KB)
...t only gives me the amount of rows in the parent... Can you please help? //parent datatable
dt = Open("C:\JMP\yield_analysis_script\used_data\edit1.jmp","visible");
//save value
f=Col Number...
Hi everybody, I would like to select rows based on the entries of selected rows from another table. Below a code snippet. The last row is not valid, but it should clarify what I m...
...nd "GSF" columns which is 6871 and 10221. I can only get the first one but can't get the latter two. Is there a script to get the rownumber for the values. Here is my script(not working) and table b...
This is probably very simple, but I could not find my answer in Scripting Index. Trying to write a script to return the total number of rows into a variable, eg, if a datatable has 100 rows...
In the lower left pane of a JMP datatable there is a list with row information, including the number of currently selected cells. Is there a JSL command that can retrieve that information d...