JMP User Community

Latest Discussions

Merge CSV in JMP 13

Hi,I like to merge few CSV files in a given directory. The files are similar format but also like to skip few lines after the headers and keep just the header for the first file. Once the files are merged, I can do the analysis on the merged file. I checked the JMP community, and did not find the best solution. I appreciate your help in providing me a script that do this. Thanks.
AT

Discussions |
May 16, 2018 4:05 PM

14281 views | 16 replies
Is there a way to insert a comment in a cell?

I have a data point and would like to attach a comment to it in the cell, similar to inserting a comment in a cell in an Excel spreadsheet. Is this possible?
aimeeh60

Discussions |
May 16, 2018 3:28 PM

14382 views | 5 replies
Failsafe JSON parsing

I have a string column that has JSON payloads in it. This is the way our partner stores messages from automated machines. The trouble is that their database sometimes gets non-JSON messages so my :payload column has rows that cannot be parsed to JSON simply. I wrapped my parse function with a Try block but even then I'm getting an alert for each row that includes non-JSON-compliant string. It even...
burakbagdatli

Discussions |
May 16, 2018 2:22 AM

6522 views | 3 replies
Joining tables with different column lengths

Hi, I have 2 tables say A and B. Table has a number columns including name.Table A has 10 names.Table B is a referencelist which has 1000 names and corresponding ages. Is there a way to join the 2 tables so that the new joined table has only 10 names from Table A and respective ages from Table B?when I tried this , got an error saying columns do not match. TIA
ENTHU

Discussions |
May 15, 2018 8:59 PM

5200 views | 4 replies
Getting Rid of the "N" Column in a Tabulate Chart

JMP Users I have developed a Tabulate Chart to show the installation status of some hardware, please see the attached file. My question is I would like to get rid of the last "N" column in the Tabulate chart and cannot figure out how to do that? See the script below for the Tabulate Chart:
fuscod

Discussions |
May 15, 2018 11:06 AM

12051 views | 6 replies

Previous
Next

Latest Discussions

Joining tables with different column lengths

Hi, I have 2 tables say A and B. Table has a number columns including name.Table A has 10 names.Table B is a referencelist which has 1000 names and corresponding ages. Is there a way to join the 2 tables so that the new joined table has only 10 names from Table A and respective ages from Table B?when I tried this , got an error saying columns do not match. TIA
ENTHU

Discussions |
May 15, 2018 8:59 PM

5200 views | 4 replies
Getting Rid of the "N" Column in a Tabulate Chart

JMP Users I have developed a Tabulate Chart to show the installation status of some hardware, please see the attached file. My question is I would like to get rid of the last "N" column in the Tabulate chart and cannot figure out how to do that? See the script below for the Tabulate Chart:
fuscod

Discussions |
May 15, 2018 11:06 AM

12051 views | 6 replies
ANOVA, Dunnett, and Overall Type 1 Error

Hello, I have equally-spaced data (8 points in time) and four treatment groups (control, low, mid, and high). The number of subjects in each treatment group is identical, with no missing data points. I have three key response variables on which I would like to perform statistical testing. My thought was to perform a one-way ANOVA for each time point (8 tests per response variable). If any ANOVAs c...
bio_grad

Discussions |
May 13, 2018 10:10 AM

3476 views | 1 replies
Problems with Execute SQL: JMP crashes, need help troubleshooting

I'm rewriting an old App to include more features. Part of the App is pulling some data from a database. I'm copying that code exactly as it was in the old App.When I'm tyring to execute that code in the new app, JMP crashes violently. It was giving me some error windows, now it just stops running. It does produce crash reports, though, in "...AppData\Local\Temp\JMPCrashReports\13". So, if I isola...
miguello

Discussions |
May 11, 2018 1:34 PM

3575 views | 2 replies
UNION QUERY - HOW TO DO IT?

Dear All, We are looking for your help. We are creating a query that extract the data from several tables (as usual), but we would like to do a Union between two primary tables. An example of how our SQL query looks like is below. How can we achieve this using the Query Builder? So far, we can query the db using only the first part of the query before the UNION statement. We have read the JSL book...
anaheilman

Discussions |
May 10, 2018 2:16 PM

4703 views | 5 replies

Previous
Next

Latest Discussions

Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1711 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3814 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2634 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2260 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3501 views | 0 replies