cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • JMP script to create sequence column based on group from another source column

    I have a large data set where the cycle changes over time. I would like to create a column that has an index by 1 at the start of each cycle and continues to count up until the next cycle starts then the counts starts back at 0. I have tried using the count and sequence functions shown below but I run into problems when my second cycle has more values that my first cycle (see diagram below where t...

    thedellette thedellette
    Discussions |
    Jul 2, 2021 8:19 AM
    2634 views | 3 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 Jon_Armer
    Discussions |
    Jul 2, 2021 7:26 AM
    2224 views | 3 replies
  • How to force a new best guess a column (modeling type and data type)

    I am initiating a column as character containing empty values. Later on, this column will be populated with data from a data base that can be any type. By having characters no transformation is done by JMP. How can I force a new best guess via JSL?   

    FN FN
    Discussions |
    Jul 2, 2021 7:24 AM
    1790 views | 3 replies
  • How do I Add Context to Text Explorer Results?

    I am new to JMP and just starting to use the Text Explorer to look for insights in free text responses from consumer research studies. Once the analysis has identified the key terms found in the responses is there an automated way to look at the most common context for each term? For example if the consumer study was looking at the performance of a new paper towel we would expect the term "absorb"...

    MKinninmonth MKinninmonth
    Discussions |
    Jul 2, 2021 2:03 AM
    1405 views | 2 replies
  • Recode columns containing character value at the end of a column

    Hello, I have a table likeIDColumn2ABC001235G ABC001234 ABC001235 ABC001234D ABC001234F  I would like to recode the ID column such that all my values like 'ABC001234D' and 'ABC001234F' become 'ABC001234' - basically I want to drop that last letter in the statement. However, I cannot do this through manual process. There are too many rows to do and I couldn't possibly write it manually for each ID ...

    saneal saneal
    Discussions |
    Jul 2, 2021 12:14 AM
    2544 views | 3 replies

Latest Discussions

  • 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 Jon_Armer
    Discussions |
    Jul 2, 2021 7:26 AM
    2224 views | 3 replies
  • How to force a new best guess a column (modeling type and data type)

    I am initiating a column as character containing empty values. Later on, this column will be populated with data from a data base that can be any type. By having characters no transformation is done by JMP. How can I force a new best guess via JSL?   

    FN FN
    Discussions |
    Jul 2, 2021 7:24 AM
    1790 views | 3 replies
  • How to configure factors when another factor depends on each other

    Hello, I'm fairly new to this community. I'd really appreciate any help you can provide! I'm trying to construct a classical screening DOE, but my factors are a bit funny..My process is a calendaring process, where the gap between two rolls can be adjusted in 2 ways: mechanically or hydraulically.Mechanically setting it means there is absolutely no give, while hydraulic adjustment has a little giv...

    merkis merkis
    Discussions |
    Jul 1, 2021 12:59 PM
    3515 views | 5 replies
  • Excluded Cols still plotting when I run a script, but not when I plot it manually?

    So not sure what to is going on here. I'm trying to plot this Group of cols, with several excluded. If I manually launch the FitYbyX, those excluded columns don't even show up in the pop-up and thus don't get plotted. However, when I run this script telling it to plot that Column Group, it still plots the excluded Columns. What's up with this?  dt= current data table(); ow2 = Oneway( Y( dt<<get ...

    aliegner1 aliegner1
    Discussions |
    Jul 1, 2021 10:39 AM
    1028 views | 2 replies
  • Journal To PDF - Previous Graph Title Repeated for Next Page

    A question for scripting: I send a number of tables and graphs to a journal which i then save as PDF. What is very irritating, is that the last graph title from the previous page gets repeated on the next page, even though that shows other information.I add page breaks, I close all reports, I close all windows, nothing helps. Anyone an idea? 

    UrsulaGarcz UrsulaGarcz
    Discussions |
    Jul 1, 2021 9:18 AM
    1084 views | 1 replies

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 GGfGA
    Discussions |
    Jun 30, 2021 10:03 AM
    873 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 jach
    Discussions |
    Jun 22, 2021 11:06 AM
    729 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 aliegner1
    Discussions |
    Jun 17, 2021 3:43 PM
    968 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 Benjamin_S
    Discussions |
    Jun 3, 2021 7:59 AM
    1272 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 caseylott
    Discussions |
    Apr 28, 2021 12:03 PM
    1263 views | 0 replies
view all discussions