Duplicate Rows
I have a table in in JMP 16.0 that has duplicate rows with respect to one of the columns. I would like to retain the first row and delete all the following rows. For example from Table 1 to Table 2. Table 1 Table 2
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI have a table in in JMP 16.0 that has duplicate rows with respect to one of the columns. I would like to retain the first row and delete all the following rows. For example from Table 1 to Table 2. Table 1 Table 2
Hi All, I'm trying to write a column formula that will look at the difference in date between two rows and if >= than a certain value (in this case 4 days), then the column should decrement the phase value. If the date difference is <4 then it should keep the previous phase value. I've defined two local variables in the formula: phase and MinDaysbreak, which is the minimum days between phases (4...
Hello,I would like to set a RSM DOE using factors A1, D1, A2 and D2:But excluding all combination of factors that give a value of (A2/A1)*(B1/B2) lower than 0.1 and higher than 10.I inserted the following line as a Disallowed Combinations Expression: However, I still get 0.01 and 100 for the (A2/A1)*(B1/B2) in the proposed experiment set: Where is the problem in the script? Why doesn’t it work the...
Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
Greetings to all!
Can you please suggest how should a password protected SAS data file be opened/queried by passing the username/pw from the JSL script? A line of code would help... Thanks
Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
Hello, this is the current graph I have. I want to include both the error bars and the value labels for the mean, but they are overlapping. Is there anyway I can move the value labels slightly higher so they do not overlap with the value labels? Alternatively, if anyone knows how to make a caption box instead of stacking the numbers vertically have them go horizontally, that would work too. Thanks...
I'm having a conceptual problem figuring out how local variables work. I'll simplify the issue to focus in on what is confusing to me. I create a local variable, say t0, with a value of 5. Then I write a column formula to increment this value by 1... either t0=t0+1 or t0+=1 (it doesn't seem to matter), the result that I expected was that when JMP evaluated each cell in the column, it would increme...
Hi,
is that a way to remove any string that contain numbers using JSL? Example:
I ate 4 apples and 2 bananas
the model number is 0998GBELS03/45 is the ratio to check Targeted Output:I ate apples and bananas
the model number is is the ratio to check
Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory";
Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...
Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory";
Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...
w = New Window("window", <<Journal, hlb = hlistbox() );
w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" );
w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...
Hello - First of all, I'm speaking very much as a non-statistician here. I have a paper I'm trying to replicate that is doing hierarchical clustering with multiple similarity functions and grouping methodologies, and then using an Adam's consensus to find a sort of "optimal" dendrogram, if you will. I looked at their software they were using, and its been out of comission for a good 15 years. JMP ...
Hi, is it possible to use a limits table to load specifications grouped by some factor in platforms other than Process Screening? Ideally I'd like to use the limits table in the distributions platform. Thanks in advance, Alicia
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...