JMP User Community

Latest Discussions

Open/Read fixed width text file in JMP

Hi All,I have a number of fixed width data files(all in same structure) as txt format those do not have column names. Can anyone suggest a template JSL Script that I can customize/use to open any of the files, assign column names, and save as as JMP table? Thanks in advance.
monir

Discussions |
Apr 19, 2024 11:52 AM

1681 views | 3 replies
How to remove all blank rows from data table?

I have an instrument that outputs data in an Excel sheet with many blank rows dispersed randomly. I normally do the cleanup in Excel, but am moving to doing all my work in JMP. What's the easiest way to remove all blank rows from a data table? Each batch of samples will have the rows in different positions, so it can't just be by location. Thanks!
Mcc99

Discussions |
Apr 19, 2024 8:06 AM

9892 views | 5 replies
How to handle user password information in JSL ( ODBC connection strings )

I am connecting to a database using ODBC, which has a specific user and password created for that purpose (not possible to use windows Active Directory, or other).

When the query is built, the table script stores the user ID.

Password is asked but it can also be coded directly into the connecting string in JSL.

What are the best options to handle such situations in JSL?

JMP files may be shared but upd...
FN

Discussions |
Apr 19, 2024 5:09 AM

7091 views | 11 replies
How do I parse data to column then stack them with multiple special characters

I have a raw data need to text to column with many special character, then stack them. Could you please help provide solution by JSL script for generic case. Please help to refer my excel file for detail
ducthinh279

Discussions |
Apr 19, 2024 1:25 AM

3129 views | 4 replies
How to get X axis value by jsl?

Hi,how could use jsl to get X axis Value by JSL?like oneway anovaI want to get first /second name in x-axisthanks
Wei1

Discussions |
Apr 19, 2024 12:43 AM

910 views | 1 replies

Previous
Next

Latest Discussions

Open/Read fixed width text file in JMP

Hi All,I have a number of fixed width data files(all in same structure) as txt format those do not have column names. Can anyone suggest a template JSL Script that I can customize/use to open any of the files, assign column names, and save as as JMP table? Thanks in advance.
monir

Discussions |
Apr 19, 2024 11:52 AM

1681 views | 3 replies
How to get X axis value by jsl?

Hi,how could use jsl to get X axis Value by JSL?like oneway anovaI want to get first /second name in x-axisthanks
Wei1

Discussions |
Apr 19, 2024 12:43 AM

910 views | 1 replies
Finding the perfect lightweight hiking food

This rabbit hole is just for fun: I found a huge spreadsheet that lists data for thousands of potential hiking foods. My question is: What is the most lightweight mixture of foods that you can bring camping that has the ideal balance of macronutrients? (60% carbs, 20% protein, 20% fats). Thoughts:1. You want to minimize the weighted average g/calories.2. I'll assume you can get micronutrients by ...
RatioModelOx453

Discussions |
Apr 18, 2024 2:45 PM

2975 views | 6 replies
overlapping points with Overlay

I want to use Overlay to get different markers and legend entries for a subset of my data points.Unfortunately, as soon as I activate Overlay, the points with the special markers overlap with the other points (top graph): What is the best way to get:- the markers- the legend entries- non-overlapping, nicely positioned data points View more...Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big C...
hogi

Discussions |
Apr 18, 2024 12:50 PM

1818 views | 2 replies
What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

DL

Discussions |
Apr 17, 2024 4:50 AM

737 views | 0 replies

Previous
Next

Latest Discussions

What is the best approach to perform differencing for a time series data with seasonality and a shock event? What to do if you can't find the differencing (d)?

DL

Discussions |
Apr 17, 2024 4:50 AM

737 views | 0 replies
JMP Broadcasting statistical analysis

We want to investigate the way which is suitable for searching predict and forecasting of medical region.
For example, using stepwise parameter analysis, partial results of marketing will be used by data driven.
Moreover we want to develop marketing extensive predictive analysis from marketing perspective.
JMPLOVE1234

Discussions |
Apr 15, 2024 1:49 AM

725 views | 0 replies
Hover label filter generation doesn't support selection filter, skipping.

what is the reason for this warning - what does it mean?
hogi

Discussions |
Apr 14, 2024 11:26 AM

577 views | 0 replies
graph builder bug - x group shift

(JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...
ShlomiB76

Discussions |
Apr 14, 2024 12:08 AM

721 views | 0 replies
Process development with multiple factors

Hi everyone, I'm currently engaged in a process development project with the goal of 1) minimizing the total process time while 2) maintaining or enhancing the yield. This objective is similar to viral vector production case, where maximizing virus yield in the shortest production time is crucial. After consulting with subject matter experts, we've pinpointed 10 factors for potential modification....
BJK_JerseyBoy

Discussions |
Apr 9, 2024 2:47 PM

797 views | 0 replies