JMP User Community

Latest Discussions

PostgreSQL function: is it a bug?

Hi,I have a problem with queries on a PostgreSQL database using the JMP query builder...
Indeed some PostgreSQL functions seem not working properly in the query builder...For example if I want to retrieve part of a string from the position of one of the character:
this command could ben written in PostgreSQL:SELECT substring('Thomas' from position('h' in 'Thomas') for 2) AS bug_test But if I write i...
Franck_R

Discussions |
Oct 22, 2020 5:56 AM

2031 views | 2 replies
Pick File: Syntax of filterList argument

I am having trouble using the pick file command, in particular the filterList argument, and unfortunately, the scripting index does not cover my case.I want to set the filter to only csv (or Text files) during selection, as I can when using Open, and triedNames Default To Here( 1 ); mypath = Pick File( "Select csv File", {"Text Files|txt;csv"} );but when executing the script, the filter is set ...
Feli

Discussions |
Oct 22, 2020 5:36 AM

1949 views | 2 replies
Question about "word" formula, purpose to split one character and get key shorten word

I have one table with one column, name is "Batch ID", I want to use one script to generate one column, name is "Short ID", formula use Word( 2, :Batch ID, "L22DD1" ), only want to get 2nd word, for example, E3L22DD1K27--->K27, but how come after run JSL, its outcome is K2 not K27? kindly help to sugget whether have other solutions if it not work? Batch IDShort IDM3L22DD1K2K2E3L22DD1K45K45M3L22DD1K...
qspringleaf

Discussions |
Oct 22, 2020 2:16 AM

3271 views | 5 replies
Script to Save Residuals of Spline Fit

Hello, Anyone knows how to write a script to sava residuals (or predicteds) as a new colum for spline fit? It is easy if i do it manually, just need to select Save Residuals in the dropdown red triangle. I know how to write scripts to save residuals as a new column for liner fit using Fit Model. However, I often need to fit time-trend data using standardized x spline fit, and i am not sure if ther...
Peng

Discussions |
Oct 21, 2020 2:13 PM

11161 views | 9 replies
Count Sum of Repeat Occurrences By Specified Variable?

I would like to create a count sum formula which sums the number of occurrences of a value by a specified column variable.I want to know by a specified column variable value (i.e. Month) how many times did the same value appear in the column of interest.Example: Sum Type of Fruit By MonthNew Column ( "Count_Fruit_Mo", numeric, continuous, ...
aandw

Discussions |
Oct 21, 2020 11:48 AM

15424 views | 6 replies

Previous
Next

Latest Discussions

PostgreSQL function: is it a bug?

Hi,I have a problem with queries on a PostgreSQL database using the JMP query builder...
Indeed some PostgreSQL functions seem not working properly in the query builder...For example if I want to retrieve part of a string from the position of one of the character:
this command could ben written in PostgreSQL:SELECT substring('Thomas' from position('h' in 'Thomas') for 2) AS bug_test But if I write i...
Franck_R

Discussions |
Oct 22, 2020 5:56 AM

2031 views | 2 replies
How to close database connection after running a New Sql Query?

Steps to reproduce: Run any new sql query: query << Run Foreground( OnRunComplete( Write( "Number of rows in query result: ", N Rows( queryResult ) ) ) ); MyRunCompleteFunc = Function( {dt}, {Default Local}, Write( "Number of rows in query result: ", N Rows( dt ) ) ); query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );Next, if you try to delete the database, it will say that jmp ...
douglaschong

Discussions |
Oct 21, 2020 11:30 AM

2252 views | 1 replies
moving labels on GraphBuilder

I feel like this should be Graphbuilder 101, but I am stumped. So, I just want to make a couple of pie graphs and add the percentages as labels. But the labels are put in weird places, sometimes to where they can't be read. I thought you could actually manually drag text in some instances, but I failed there. I attached two scripts in the uploaded table ("test graphs"). Normally, you could just ad...
abmayfield

Discussions |
Oct 21, 2020 6:40 AM

4120 views | 3 replies
Subset data after filter

hello Everybody !I have a problem in my script.I have a big data table and i would like to subset some lines.I did a data filter and then subset or show subset, but i don't have "time" to select the filter in the window....how can i say in the script i have select first my filter and then subset the data tablei tried with a wait but it's not the best waythis is my script and i link my data basetha...
MargauxR

Discussions |
Oct 20, 2020 5:56 AM

1653 views | 1 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1156 views | 0 replies

Previous
Next

Latest Discussions

Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1156 views | 0 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1409 views | 0 replies
order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! :)https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

986 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

1101 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

1489 views | 0 replies