how to open/save a data file on sharepoint in JSL?
I tried to use dt = Open("https://company.sharepoint.com/.../myfile.jmp"); got error: Internet Error: 403 in access or evaluation of "open". Any idea? Thanks.John
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI tried to use dt = Open("https://company.sharepoint.com/.../myfile.jmp"); got error: Internet Error: 403 in access or evaluation of "open". Any idea? Thanks.John
Hello,
I have successfully made an interactive html report when doing the File -> SaveAs method, however, I'm having issues getting the interactive html to show the data filters when saving in jsl code. Can someone take a look and see if I'm missing something obvious here?
Here is the code I'm using:
JMP17
v2 = dtconcat << Graph Builder(
Size(951, 734),
Show Control Panel(0),
Variables(X(:
...
I have my main data table broke down in to few tables using subset function. Then I am doing some operations and trying to merge them back using the update function. But sometime time I only have one table and sometimes 2 tables. How can I tell script to continue if second table doesn't exist. // Update data tables
Data Table( "Material A" ) << Update(
With( Data Table( "Material B" ) ),
Match Colum...
My code to do this is below. Im not getting errors but its not working. I check the columns and they don't have the spec limits. The log is showing the following:spec_limits = {LSL(lsl), USL(usl), Show Limits(1)};
:Column_Name << Get Data Type() = "Character";
:LSL << Get Data Type() = "Numeric";
"Column:";
column_name = "MST";
"LSL:";
lsl = 9;
"USL:";
usl = 12.5;
spec_limits = {LSL(lsl), USL(usl)
...
Hi all, I have a question regarding the tagging of specific data points in graph (GraphBuilder script). I would like to find an easier way, and maybe you can help. In the following, I describe how I usually do that.I usually import Excel data tables to JMP when new data is added (cumulative).With the new generated JMP table, I first copy the GraphBuilder scripts from the previous JMP data table an...
I tried to use dt = Open("https://company.sharepoint.com/.../myfile.jmp"); got error: Internet Error: 403 in access or evaluation of "open". Any idea? Thanks.John
Hi all, I have a question regarding the tagging of specific data points in graph (GraphBuilder script). I would like to find an easier way, and maybe you can help. In the following, I describe how I usually do that.I usually import Excel data tables to JMP when new data is added (cumulative).With the new generated JMP table, I first copy the GraphBuilder scripts from the previous JMP data table an...
Is the design space profiler available only in JMP Pro? If not,is there any other way to get Design space profiler in JMP16?
In a data-table, can the Pass/Fail columns be overwritten when new spec limits are updated?I need "P" or "F" to be overwritten for every row.....in each Pass / Fail column (associated with each test).If someone has a jsl script for this,.... that would be perfect >
Hi,
I have a dataset where the same ID appears in multiple rows, each with 1 to 3 categories. The columns range from costA to costZ, and I need to consolidate them into a single "Cost" column. My goal is to group by Category 1 according to specific criteria (1 if Category 1 < 2000, 2 if Category 1 = 2000 - 4000, 3 if Category 1 = 4000 - 6000, 4 if Category 1 = 6000 - 10000, 5 if Category 1 > 10000...
Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...
When I run cluster analysis --> LCA with ordinal variables (numeric, ordinal), the probability formula appears to be treating the variables as nominal, rather than ordinal. For each variable, there are 5 levels (i.e., 1-5). If being treated as ordinal, wouldn't the probability formulas reflect an order for each level where 1 may have the smallest probability and 5 the largest? As you can see below...
Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?
Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer(
Text Columns( :col1)
);
obj << Stemming("Stem for Combining");
obj << Add Recodes(
{{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl
...
Hello - I have a data set that comes from an external measurement and the software that comes with the instrument automatically calculates the property and error bars that I'm looking for. Is there a way to include the error as a column property without doing a custom column property? I know there's a saved model error property, but fitting a custom model would introduce it's own issues as the mod...
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...