JMP User Community

Latest Discussions

Apply script to multiple data tables

I have a script where I open a txt file in JMP as a data table and then move the column names listed in row 7 to the column headers. How can I apply this to multiple data tables? My current script is not working. I have JMP16. Thanks. dt_list = Multiple File Import(); //additional known text here to open files table_script = expr( //Move the column names listed in row 7 to the column headers dt...
Raquel

Discussions |
Jan 16, 2024 11:55 AM

2138 views | 4 replies
How to store variable values in a list properly?

The first 6 lines of the script below work as I expected, with output copied below.Then I tried to store the values of these variables in a list, which didn't go well. It appears that the variable names instead of the values were stored. How do I store the variable values in the list? Thank you! dt = new table("my table", new column("X", set values({-0.35, 0.15, 0.3}) ) ); dt << new column("Y", s...
CurseOfLizard13

Discussions |
Jan 16, 2024 7:49 AM

1692 views | 2 replies
JSL: How to call outlinebox on calculated string, like: Report(platform)[OutlineBox(parse("Stepwise Fit for " || yparm))]

Hello, i try to call my outlinebox report by substituting with the table variable name (character string) I want to look at.I first tried without substitution and it worked well.Then i did: NamesDefaultToHere(1); yparm = "MyResponse1"; dt = DataTable("MyDataTable"); ... platform = dt << Fit Model( ... , Personality("Stepwise"), ... ); wait(0) ; TableToGet = Report(platform)[OutlineBox(parse("S...
MeanTableColt51

Discussions |
Jan 16, 2024 3:05 AM

1658 views | 3 replies
How to run multiple SQL queries in parallel, wait for fnish, and get list of datatables

Hi, I would like to have a function, that (i) runs multiple SQL queries in background (connection and sql statements from string lists with arbitrary lengths), (ii) waits until all queries are finished, and (iii) returns a list of datatables. Please find my code below. I don't know how to gather the data tables correctly. Thank you in advance. Run_SQL_Queries = Function({o_connections, o_sq...
UEJ

Discussions |
Jan 15, 2024 3:57 PM

3881 views | 3 replies
JMP Script question: How to use variables to control "show group means"?

Hi all:
I have a question about Variability chart. I am trying to use a variable "aaa" to control if the a certain variability chart need group means.
Below is the simplified code:
According to the log file, it seems that jmp does not substitute aaa to 0 so that it still plot group means even if
aaa=0.
Is there any way to let jmp to realize aaa is a variable?
Note: The values of aaa could be 0, 1 or "Sp...
ytwu

Discussions |
Jan 14, 2024 10:37 PM

1059 views | 1 replies

Previous
Next

Latest Discussions

JMP Script question: How to use variables to control "show group means"?

Hi all:
I have a question about Variability chart. I am trying to use a variable "aaa" to control if the a certain variability chart need group means.
Below is the simplified code:
According to the log file, it seems that jmp does not substitute aaa to 0 so that it still plot group means even if
aaa=0.
Is there any way to let jmp to realize aaa is a variable?
Note: The values of aaa could be 0, 1 or "Sp...
ytwu

Discussions |
Jan 14, 2024 10:37 PM

1059 views | 1 replies
Direct passing argument to a script file

Hey, i wish to pass argument str1, a string argument to a separate script named: "script2run.jsl" for example, nad that script uses str1 argument and print a message such as : print("This is the important string I successfully passed: " || Eval(str1)) ; a different script that create a window that will be saved as journal for later usage will triger that script through buttons that would be ...
CoverChikaka

Discussions |
Jan 14, 2024 8:27 AM

1825 views | 4 replies
Load .NET dll and call a function in JSL

Hi I am very beginner of JSL and am trying to create a JMP application for our team.To do this, I realized that I have to load c# dll to the JSL and call a function from there. I have read the part of DLLs in JMP scripting guide but I am not so sure this can be applied for .NET dll.Does anyone have an experience of loading .NET dll and calling a function from there in the JSL?
ejesjh

Discussions |
Jan 12, 2024 7:40 AM

2700 views | 1 replies
String to image conversion?

Hi, I have a table that contains PNG images in some string format (exported using fig.write_image in Python). Is JSL capable of doing an image conversion of a string?
Jackie_

Discussions |
Jan 10, 2024 7:01 PM

1961 views | 2 replies
Regex backreference followed by a number (unambiguous backreferences)

I'm scripting something to replace column names based on a regex match. I iterate through all columns and regex regex match with a new string. Works well and handy for shortening col names - except when I am replacing to a string that starts with a number - this is because the backreference gets messed up (\1 becomes \133 in the case below)In python, there is 'unambious backreference' to work arou...
jetpeach

Discussions |
Jan 10, 2024 5:43 PM

2539 views | 1 replies

Previous
Next

Latest Discussions

Copy Columns - selected rows

Copy Columns from the right-click context menu of a column header is very useful. Just copy the column(s) - with all the settings ... and paste it into a JSL script - or another table. There is a hidden feature:
When rows are selected, the values of the selected rows are used as arguments of the Set Values() command and will populate the cells of the new column. So, when you select all rows before...
hogi

Discussions |
Jan 3, 2024 1:27 PM

1226 views | 0 replies
Documentation for Promise/async http requests

Hi, I was wondering if anyone knows of any documentation for Promise objects. So far I am finding fairly little in the scripting index or at https://www.jmp.com/support/help/en/17.2/index.shtml. I am currently working from the Send documentation, which gives an example and demonstrates that you can use `<< On Response` and `<< On Error`, but not what else, if anything you can do with a Promise obj...
mat-ski

Discussions |
Dec 22, 2023 9:45 AM

836 views | 0 replies
Keyboard shortcuts

[More Topic Containers like this] Jmp Help/Keyboard Shortcuts assign new Keyboard ShortcutsAssigning-keyboard-shortcuts-for-frequently-used-options comment/uncomment blocks of code (international keyboard)A shortcut can be set in the menu customization Editoradd keyboard shortcuts for your own functionsadd them to the main menu/ to a toolbar and assign a shortcutadd keyboard shortcuts for "open...
hogi

Discussions |
Nov 26, 2023 1:38 AM

1133 views | 0 replies
Could JMP optimize factors with uncertainty?

Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example:
Marco1

Discussions |
Nov 21, 2023 9:08 AM

920 views | 0 replies
Caution: Places where Jmp does something unexpected

Definitely, JMP is Not a Spreadsheet . And that's great!! Besides this difference, there are other places where Jmp doesn't do/behave/produce what a newbie / innocent Jmp user expects.
If a user knows these issues and the remedies and workarounds - he/she can
a) save a lot of time b) be safe from data loss c) be sure that the results are as expected.

[More Topic Containers like this] Topicdescrip...
hogi

Discussions |
Nov 17, 2023 4:15 AM

1404 views | 0 replies