User Community

Latest Discussions

programming functionals (or functions that generate functions)

I have a problem where the solution I want is to use a function to generate a different function. Here's a toy example. I expect it to return [3,4,5]. it doesn't work as I hoped because apparently the passed argument (offset) isn't available to the anonymous function that is returned. My guess is that there is a way to do this with substitution, but I couldn't figure it out. funWrapper = Function(...
Mittman

Discussions |
Apr 2, 2021 6:16 PM

5887 views | 8 replies
Using JSL to download Web JSON data, can be directly written into the matrix?

A table in all digital format can be downloaded using the following JSL.u = "http……"; txt = Load Text File( u ); loc1 = "[{"; offset = Contains( txt, loc1 ); If( offset, txt = Substr( txt, offset, Length( txt ) ) ); loc2 = "}]"; offset = Contains( txt, loc2, -1 ); If( offset, txt = Substr( txt, 1, offset + 1 ) ); d1 = JSON To Data Table( txt );//without going through a "d1" file.
How to write the...
lwx228

Discussions |
Apr 2, 2021 4:18 PM

2023 views | 2 replies
Create subsets from huge table (3,632,135 rows)

Hi all, I have a big dataset with more than 3 million rows. The table contains 1105 ID (0-1104). Each ID has 3287 rows. So, I want to create 3287 subsets, and each subset contains 1105 ID lines.Could you please help me to find the solution?I attached the part of the dataset.
giaMSU

Discussions |
Apr 2, 2021 2:45 PM

1703 views | 1 replies
How to repeat values in a column when they are strings

Hi everyone!

I've used this script below for numerical values If( Is Missing( :Name( "For Calc - Data1" ) ), Lag( :Name( "Data1" ), 1 ), :Name( "For Calc - Data1" ) )
With the resulting table looking like this For Calc - Data1Data11212 12 123333 33 However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error sa...
user8421

Discussions |
Apr 2, 2021 1:49 PM

1930 views | 1 replies
How do I join two tables based on timestamps that don't exactly match?

Hi everyone! I am having an issue where I have Data Table 1 as shown below with a timestamp column and various columns of data TimestampColumn AColumn B02/08/2021 11:45 AMA1B102/08/2021 1:39 PMA2B202/08/2021 11:37 PMA3B302/13/2021 12:01 AMA4B402/13/2021 4:00 PMA5B502/13/2021 10:22 PMA6B602/18/2021 9:00 AMA7B702/18/2021 12:01 PMA8B802/21/2021 9:15 AMA9B902/21/2021 11:50 AMA10B1002/21/2021 3:00 PMA1...
user8421

Discussions |
Apr 2, 2021 11:20 AM

8218 views | 5 replies

Previous
Next

Latest Discussions

Using JSL to download Web JSON data, can be directly written into the matrix?

A table in all digital format can be downloaded using the following JSL.u = "http……"; txt = Load Text File( u ); loc1 = "[{"; offset = Contains( txt, loc1 ); If( offset, txt = Substr( txt, offset, Length( txt ) ) ); loc2 = "}]"; offset = Contains( txt, loc2, -1 ); If( offset, txt = Substr( txt, 1, offset + 1 ) ); d1 = JSON To Data Table( txt );//without going through a "d1" file.
How to write the...
lwx228

Discussions |
Apr 2, 2021 4:18 PM

2023 views | 2 replies
Create subsets from huge table (3,632,135 rows)

Hi all, I have a big dataset with more than 3 million rows. The table contains 1105 ID (0-1104). Each ID has 3287 rows. So, I want to create 3287 subsets, and each subset contains 1105 ID lines.Could you please help me to find the solution?I attached the part of the dataset.
giaMSU

Discussions |
Apr 2, 2021 2:45 PM

1703 views | 1 replies
How to repeat values in a column when they are strings

Hi everyone!

I've used this script below for numerical values If( Is Missing( :Name( "For Calc - Data1" ) ), Lag( :Name( "Data1" ), 1 ), :Name( "For Calc - Data1" ) )
With the resulting table looking like this For Calc - Data1Data11212 12 123333 33 However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error sa...
user8421

Discussions |
Apr 2, 2021 1:49 PM

1930 views | 1 replies
How do I join two tables based on timestamps that don't exactly match?

Hi everyone! I am having an issue where I have Data Table 1 as shown below with a timestamp column and various columns of data TimestampColumn AColumn B02/08/2021 11:45 AMA1B102/08/2021 1:39 PMA2B202/08/2021 11:37 PMA3B302/13/2021 12:01 AMA4B402/13/2021 4:00 PMA5B502/13/2021 10:22 PMA6B602/18/2021 9:00 AMA7B702/18/2021 12:01 PMA8B802/21/2021 9:15 AMA9B902/21/2021 11:50 AMA10B1002/21/2021 3:00 PMA1...
user8421

Discussions |
Apr 2, 2021 11:20 AM

8218 views | 5 replies
Code Folding is catching too many lines

I have set "if" blocks to be foldable, and I have been using them like this If (1==1, // comment abc <foldable code block 1 > ); If (1==1, // comment xyz <foldable code block 2 > ); But often, the first block will catch later blocks and fold them all together. The code work without a problem, but is is sometimes hard to find the code, it is lost in the folds. Is there a solution to t...
mann

Discussions |
Apr 2, 2021 8:36 AM

3684 views | 5 replies

Previous
Next

Latest Discussions

Workflow ideas for new projects

Hi all,

After a year of playing around with JMP, I'm extremely satisfied with using it as my main data exploration platform. However, I'm overwhelmed about the tremendous amount of ways I can begin to explore my data. When starting a new project, let's say a biomonitoring study for instance, where does one begin their workflow? Are there any literature on JMP for starting a project from beginning ...
MikeDereviankin

Discussions |
Mar 30, 2021 1:41 PM

1571 views | 0 replies
Manipulating data table properties (cell width/height) INSIDE application module

Hello! I have created and Application consisting of data from multiple data tables, plotted it into few separate cross-linked graph builders and hosting one preview of data table (which has images, which is kind of the point). I would like to manipulate the cell width / height of the data table cells included into this application/dashboard, but the task seems impossible. For only the data table, ...
plotMaster

Discussions |
Mar 27, 2021 3:54 PM

1947 views | 0 replies
What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1780 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1606 views | 0 replies
generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1425 views | 0 replies