JMP User Community

Latest Discussions

Copying Row values to other Column

Hello, Kindly help me I'm stuck when putting a formula into other column.Here is expected output if SerialNumber is not empty copy row to Column ChipID else copy the same SN.dtraw << New Column("ChipID", Character, Formula( For( i = 1, i <= N Rows(dtraw), i++, If( Is Missing( :SerialNumber), :ChipID[i] = (:SerialNumber[1] & i = 1), :SerialNumber ) ) );
JeffO

Discussions |
Sep 27, 2021 1:56 AM

1454 views | 2 replies
JSL how to reference a table in graph builder

Hallo all, I use a JSL script to generate two tables dt1 and dt1 from an SQL server and then I want graph builder to plot two columns from the first data table I generated. Example below: dt1 = Open Database( "BLA", " SELECT col1, col2 FROM BLA", "data table 1" ); dt2 = Open Database( "BLA", " SELECT col1, col2 FROM BLA", "data table 2" ); Graph Builder( Variables( X( :col1 ), Y( :Tcol...
valeria

Discussions |
Sep 26, 2021 11:47 PM

2772 views | 3 replies
Determine Week of Year and Day of Week Based on Year, Date and Time

Hello all, My company uses a fiscal calendar where one year has only 52 work week(WW). The weeks start on Saturdays, time 19:00 (hh:mm). The day of week (DOW) is determined based on the time 19:00. I am trying to determine it by using Week Of Year() and Date of Week() functions but I do not get the desired outcome. Has anyone created JSL script to determine the week of year and date of week based...
bzanos

Discussions |
Sep 26, 2021 9:58 PM

2441 views | 2 replies
Saving Multiple Data Tables to an Excel Workbook

Hi -
I have a jsl script made with Jmp 12 that processes huge data table and generates 9 data tables with different summaries.

I am saving these off currently as 9 csv files. I would like to condense it to ONE Excel workbook with 9 tabs.

I understand saving each data table to excel (xlsx) is an option. How can I have 9 sheets saved to one excel via Jmp 12?

Appreciate any inputs/pointers. Thanks!

uProf

Discussions |
Sep 26, 2021 7:38 PM

1634 views | 2 replies
break a single column into multiple based on empty row or specific character

Hi,can someone provide advice?I have a column with structure below:
123 abcdef xxyyzz

is it possible to divide to multiple columns based on empty row (or a repeated same character) 1 a xx2 b yy3 c zz d e f
dadawasozo

Discussions |
Sep 25, 2021 8:08 AM

1005 views | 2 replies

Previous
Next

Latest Discussions

Saving Multiple Data Tables to an Excel Workbook

Hi -
I have a jsl script made with Jmp 12 that processes huge data table and generates 9 data tables with different summaries.

I am saving these off currently as 9 csv files. I would like to condense it to ONE Excel workbook with 9 tabs.

I understand saving each data table to excel (xlsx) is an option. How can I have 9 sheets saved to one excel via Jmp 12?

Appreciate any inputs/pointers. Thanks!

uProf

Discussions |
Sep 26, 2021 7:38 PM

1634 views | 2 replies
break a single column into multiple based on empty row or specific character

Hi,can someone provide advice?I have a column with structure below:
123 abcdef xxyyzz

is it possible to divide to multiple columns based on empty row (or a repeated same character) 1 a xx2 b yy3 c zz d e f
dadawasozo

Discussions |
Sep 25, 2021 8:08 AM

1005 views | 2 replies
How to estimate sample size to meet specificity and sensitivity requirements

Hi, I'm trying to calculate the sample size required for my test to meet the sensitivity and specificity requirements.I have a binary test that detects the presence of bacteria in water, if it's positive bacteria is present, if it's negative it is not present.I would like my test to have92% sensitivity (with 95% CI of 90-94%)and 90% specificity (with 95% CI of 88-92%)and I want the power to be 0.8...
Agustin

Discussions |
Sep 24, 2021 9:22 AM

2551 views | 3 replies
How to calculate adjusted variable data ？

Hello, this may be a simple question.I am trying to analyze e relationship between Adjusted Variable and Variable of Interest. I want to calculate adjusted variable data by age and sex. What JMP function should I use?
KF2

Discussions |
Sep 23, 2021 10:40 AM

1333 views | 2 replies
Does Graph Builder have a ruler tool?

Graph Builder is fantastic, it's one of the killer features of JMP. Does it have a ruler tool buried somewhere? A way to measure the distance between two points? For all the things GB does, I'd be surprised if it didn't...
BHarris

Discussions |
Sep 23, 2021 8:13 AM

2769 views | 3 replies

Previous
Next

Latest Discussions

Skip Lot Sampling Plan

Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam
AT

Discussions |
Sep 10, 2021 10:38 AM

996 views | 0 replies
Time values in xls or xlsx, csv, and JMP

Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...
fliew0410

Discussions |
Sep 7, 2021 7:25 AM

990 views | 0 replies
Error while using Azure MFA to connect with JMP

I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.
hariharan249

Discussions |
Sep 3, 2021 7:14 AM

704 views | 0 replies
Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1270 views | 0 replies
Projects Window List in JMP 15 for Mac -- Reorder?

I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses. There is a flow to the findings which I'd like to order in that Window List. Is this possible? I can't click and drag an entry for a window up or d...
datanaut

Discussions |
Aug 16, 2021 6:38 AM

642 views | 0 replies