JMP User Community

Latest Discussions

JSL select rows with certain string and make subset

Hi All, I want to select certain rows that have string ended with "452" in column "Sample_ID" and make a subset containing these rows. I try to do like below but it didn't work Names Default To Here( 1 ); Clear Log(); Clear Symbols(); Close All( Data Tables, NoSave ); Close All( Journals, NoSave ); // pick data table 1 dt1_dir = Pick Directory( "Select directory for data table 1" ); dt1_Name...
achid03

Discussions |
Jul 5, 2021 12:42 AM

3585 views | 5 replies
Classer les valeurs uniques d'une colonne selon un calcul de pourcentage

Bonjour,J'ai une table de donnée de très grande taille (environ 6 million de lignes). Elle a notamment comme colonnes une colonne Date, une colonne Référence Produit et une colonne Résultat (qui a deux valeurs possibles : OK soit NOK). Chaque ligne correspond à un test de composant.Je voudrais pouvoir laisser l'utilisateur sélectionner une période ou une date. A partir de cette période je voudrais...
Elise_B

Discussions |
Jul 5, 2021 12:20 AM

1446 views | 2 replies
Spatial zoning of a large

Can some help me with how to demarcate a plot of the field containing about 3500 data points into 24 different zones? Using Binning formula might be a great idea but I am not seeing any webinar on this.
Samboat

Discussions |
Jul 4, 2021 11:08 PM

2858 views | 8 replies
How do I change a dot to number zero

Hello,I am adding two columns and it works.However, there are some cells that have a "dot" (not zero) on the two columns that make the formula not work. Is there away to change the dots to the number zero by not manually change them one by one?Thank you,Canh
CanhKhong

Discussions |
Jul 4, 2021 11:16 AM

7313 views | 6 replies
How to seperate columns into different tables.

I have a datatable with 5 columns. Field names are from from A to Z. Now i want to seperate this table into 5 si gnetables. Every table just contain one column. The table A has one column A. Until the table E ha e one column Z. Can you give me suggestion on JSL?
GoodMan

Discussions |
Jul 4, 2021 6:38 AM

2964 views | 8 replies

Previous
Next

Latest Discussions

How to seperate columns into different tables.

I have a datatable with 5 columns. Field names are from from A to Z. Now i want to seperate this table into 5 si gnetables. Every table just contain one column. The table A has one column A. Until the table E ha e one column Z. Can you give me suggestion on JSL?
GoodMan

Discussions |
Jul 4, 2021 6:38 AM

2964 views | 8 replies
How to export a formula to excel?

Hello, I have a master prediction formula that consists of 4 different prediction formulas. To develop prediction formulas I used Boosted trees and Boosted forest. So once I combined them together to get the master prediction formula I ended up having a complex and complicated formula. As the next step, I want to export the master prediction formula to excel. I was wondering is there any way that ...
Dm1229

Discussions |
Jul 3, 2021 6:18 PM

1303 views | 1 replies
Take value from specific cell to create a column

Hello, In JSL, I want to use a specific cell value to create a column. how can I do it?From this:ID 1122 NameAgeJohan23David34Jack27to This: IDNameAge1122Johan231122David341122Jack27
ileshem

Discussions |
Jul 3, 2021 4:13 AM

2043 views | 2 replies
GLM poisson plotting

I have been trying to generate an interaction plot after GLM poission regression on JMP 14.0, but I can not do it there. I have an experimental data with three way interaction, and want to present the value in plot. Any suggestions or ideas?
Sam_UT

Discussions |
Jul 2, 2021 9:29 AM

842 views | 1 replies
FDE model selection and fit. A 'Knotty' problem...

Hi All, I'm currently trying to explore some analytical data where the response changes over time using FDE. The context is that this is an analytical method where the response of the same sample(s) are changing over time. We used a surface-response DoE design in an attempt to capture the effect of the 2 main factors and identify what is causing this change.For each experiment in the design, we ad...
Jon_Armer

Discussions |
Jul 2, 2021 7:26 AM

2198 views | 3 replies

Previous
Next

Latest Discussions

Section 508 compliance

Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful? Maybe this is a wish list item?
GGfGA

Discussions |
Jun 30, 2021 10:03 AM

853 views | 0 replies
Multi File Import of network folder slower in latest JMP version

Hello, In JMP 14, Multi File Import of a network folder was relatively fast. For example, it takes ~11 seconds to load the below folder. With JMP 16 on the same computer/folder/network, it will first spend almost 3 minutes while "discovering files", before proceeding with the above "loading file names" step. Are there any settings or options that I could change to skip the "discovering files" step...
jach

Discussions |
Jun 22, 2021 11:06 AM

707 views | 0 replies
ODBC Hive connection, change container size in the script?

Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connection settings". I was told that in python, you just add a configuration={"hive.tez.container.size":'10240'} parameter to the hive.connect call. How would I do this through JMP? I already have the Cloud...
aliegner1

Discussions |
Jun 17, 2021 3:43 PM

949 views | 0 replies
Using a List to Filter in Custom Query Builder - Question

Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...
Benjamin_S

Discussions |
Jun 3, 2021 7:59 AM

1256 views | 0 replies
Can I control text size in a word cloud inside a dashboard container?

Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...
caseylott

Discussions |
Apr 28, 2021 12:03 PM

1241 views | 0 replies