Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resources
Hi everyone, I'm trying to upload my data table into SQL & I'm having issues getting the date columns to load in.
The error I receive is this: "[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: numeric is incompatible with date"I tried using SELECT CAST to make it into a date format but that didn't work. I'm using JMP 17.0.0. I used the base code from this post & tried to adapt it ...
Bagawandoss96
In my test framework I would like to cut out the clutter that results from Prints/Writes/handled exceptions from my output file, so I tried executing test code inside of a Log Capture( Eval( testExpression ) ). My problem is that this seems to also silence any exceptions that get thrown when evaluating the testExpression, which I did not expect. As an example:Try(
logs = Log Capture(
Throw( "n...
mat-ski
I see that when Parse JSON fails in a Try, the catch block doesn't seem to get executed. I also see that parsing malformed JSON has been more problematic than this in the past (see this thread), so I grabbed the suggested parsing logic from that thread, which allows me to get the Try to behave as expected, but it seems problematic that Try has this very specific scenario where it doesn't execute ...
mat-ski
Hi, Is there a way to get a default value without any click?I want to save the default value in a variable which in this case should be "one". Any Suggestion? Here is what I triedNames Default To Here( 1 );
New Window( "Example",
cb = Combo Box(
{"One", "Two", "Three"},
<<set function(function({self},
cb << set(1, runscript(1));
selection = cb << GetSelected();
Print( "Selected: " || se...
Jackie_
Hi everyone, I'm trying to upload my data table into SQL & I'm having issues getting the date columns to load in.
The error I receive is this: "[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: numeric is incompatible with date"I tried using SELECT CAST to make it into a date format but that didn't work. I'm using JMP 17.0.0. I used the base code from this post & tried to adapt it ...
Bagawandoss96
For example when I run this script: someFunc = Function( {arg},
{},
Print( arg );
);
executor = Function( {fn, arg},
{},
fn( arg );
);
executor( someFunc, "this string" )I get an error, that seems to imply that I am calling someFunc when I am intending to pass a reference to it to executor. I am able to pass a reference by defining the function in the invocation, e.g.executor = Function(...
mat-ski
How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi
It seems the following command does not work for JMP MacOS.
Use JMP Locale Settings( 0 )
Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user?
// Configuring JMP to save CSV as commas and not
If( (Num( "3.14" ) == 3.14),
is_EN_num_format = 1, //"English numeric format"
is_EN_num_format = 0 //"Non-english");
)...
FN
Dear expert JMP users, I have a lot of data files generated by an instrument that I've used - each one is consistent in format but they are all in individual sub-folders and each folder contains other files that are not of interest.Is there a way of writing a script (I'm completely new to JMP scripting) to look in all sub-folders of a given directory, search for excel files ending in ' infos.xlsx'...
JMPinthePool
How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi
It seems the following command does not work for JMP MacOS.
Use JMP Locale Settings( 0 )
Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user?
// Configuring JMP to save CSV as commas and not
If( (Num( "3.14" ) == 3.14),
is_EN_num_format = 1, //"English numeric format"
is_EN_num_format = 0 //"Non-english");
)...
FN
Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );
List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"};
List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"};
List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"};
List4 = {"SN...
Jackie_
When I use PickFile() outside of a project, it works as noted in the scripting guide, scripting index, and other posts here in the forums. However, when I run the script within a project, the window that opens is a different one. It seems to be in order to allow you to pick a file that is saved to the project itself, but the filters do not work even though it shows the folder that I specified as d...
R2OKeefe
Dear community,I have a stacked data table, and want to exclude outliers by a Label (e.g. an element for some measurements).In the robust fit outlier platform I can detect outliers and than can select or exclude corresponding rows.For my understanding, rows that are selected than or excluded, should be exactly the same ones.And that is the case for the below sample data table used in the JSL below...
Georg
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...
jvine