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
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHello, 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
Hi All,I'm a new user in JMP scripting and need help to find bugs in my code. What I'm trying to do here is to concatenate already opened data files (dt1 and dt2). I found that the script did not concatenate the two tables. line 41 and so on was not executed plus with no error messageCan anyone help me with it? Thanks
Hi, I'm trying to concatenate files using MFI but across different folders in the same main path but due to the massive number of files in the main path, I would like to direct it to specific folders using user input. However, it seems like MFI is only able to select a single folder as the path. Another workaround I was thinking of is to search and copy the files with specific keywords in the file...
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?
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...
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
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?
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...
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?
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...
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?
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...
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...
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 ...
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...
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...
Presenter: Will Morgan, Associate Software Developer - JMP Join us for a Scripters Club...
Jump into Gauge Studies Date: Wednesday, October 15Time: 1:00 – 2:30 p.m. ETDuration...