referencing column using Column("name")
Hi, I have a "quick" question: dt = Open( "$Sample_data/Big Class.jmp" ); //// These don't work; dt << Select where( Column("sex") == "F"); dt << Select where( Column(3) == "F"); /...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, I have a "quick" question: dt = Open( "$Sample_data/Big Class.jmp" ); //// These don't work; dt << Select where( Column("sex") == "F"); dt << Select where( Column(3) == "F"); /...
I'm quite sure I will feel stupid after seeing the answers but I currently have a brain hang up. I want to refer to a column from a list of columns in a new formula in JSL (for later looping...
hello, I need just some help to use Regex function -- String is like -- "Fine.2020.Optional.(Not)" Required -- "Fine_2020_Optional" I have tried couple of combination, but not abl...
Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in i...
I have 33 Likert scale variables that measure different types of disabilities from facial expression to speech, etc. The total score across all 33 scores gives a good index of an overall disability l...
Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in i...
Hello, I am trying to add constraints to design with 4 discrete factors (X1,X2,X3,X4), where all the factors have 3 levels. What is the best way to add constraint to specify that three factors (X2,X...
Hallo! JMP Verion 16.1 Vorrede zu meinen Daten: Ich möchte einen Datensatz (2 nahezu gleiche Messysteme, darauf jeweils die 10 gleichen Personen mit 5 Wiederholungen gemessen) auswerten und den Va...
Hi guys, I'm a complete scripting newbie here so please have patience with me :crossed_fingers: . I have a data set with multiple columns and am trying to make a script that will automat...
I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days...
Hi, when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked: By selecting a row in the summary table the corresponding rows in...
Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine. I used 10 devices and measured these devices 5 time...
Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predicto...
Query Builder - date filter. SQL Server JMP version 16.2 In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the ...
Hi all, I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using th...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn how to publish data, dashboards...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-univar-11sep2024.htm...
https://www.jmp.com/en_us/events/users-groups/users-group-meetings/ph-jug-11sep24.html ...