List of Strings
To create a matrix of N identical numbers, I can use J(N, 1, number).What is the shortest (syntax) and fastest way to create a list of N identical strings?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesTo create a matrix of N identical numbers, I can use J(N, 1, number).What is the shortest (syntax) and fastest way to create a list of N identical strings?
Hello, I have 2 tables (Table1 and Table2), both queried from databases.I need to update Table1 with Table2 by matching columns (:match). The problem is: - I get :match content for Table1 with a Regex from the database with (sometimes) this format: “XXXX-YY-ZZZ”.- I get :match content for Table2 from another database with a different but consistent format: “XXXXYYZZZ”. I can manually use If() and ...
Hello,
Looking for tips on how to make my script more dynamic.
Given the snippet below we have a data table << Get as Report that we add onto a Col Box() with dynamic buttons.
Now, here lies the issue. I need to put X amount of data tables into my window and I'm not sure how to go about it since I also need to add dynamic buttons to each table. The exact amount of data tables can vary. Thanks for the...
Hi, I have a database query that returns a large table, 200+ columns, and would like to clean it up before working with.The columns have initial terms that signify the metrology tool source such as Raman, XRD, XRF, BET, PSA,...For each of these terms I would like to create a group and use the name from the above list to act as the name of the group.for example there are 20 columns that start with...
After transposing data table, Data Table( "Overall" ) << Transpose(
columns( :Value),
By( :Department, :Resource, :Chart ),
Label( :Date),
Output Table( "report overall" )
);My headers which is presented by date is no longer in order. Which I then have to mannually drag and drop to have it fixed. Luckily it only involves 7-8 columns. Nontheless, doing so eats up my time which I do not initial...
Hello,
Looking for tips on how to make my script more dynamic.
Given the snippet below we have a data table << Get as Report that we add onto a Col Box() with dynamic buttons.
Now, here lies the issue. I need to put X amount of data tables into my window and I'm not sure how to go about it since I also need to add dynamic buttons to each table. The exact amount of data tables can vary. Thanks for the...
Hi, I have a database query that returns a large table, 200+ columns, and would like to clean it up before working with.The columns have initial terms that signify the metrology tool source such as Raman, XRD, XRF, BET, PSA,...For each of these terms I would like to create a group and use the name from the above list to act as the name of the group.for example there are 20 columns that start with...
For example, this file is a txt file.TAB spacing:
Column 2 contains, column 2 contains
The maximum number of rows is 5
Can you use regular substitution to replace rows with less than 5 such symbols to complete the cell with a total of 5 similar symbols?
Make up as shown in the figure.Thanks Experts!
I'm firing events into the browser box, but every time I navigate a URL my browser level zoom gets reset.Browser level zoom like in chrome is controlled with "{ctrl} + {mouse wheel}" or "{Ctr}l + {+}" Is there any parameter I can set to control this or maintain the users previous setting?Coming in at 100% every time isn't ideal.I have full control of the web page too, but I don't want to do a CSS...
I'm trying to add a factor to a DOE using a variable instead of hard coding the levels. The end goal is to provide the user with a simple interface set the levels for one of the factors. The following code doesn't work and the factor just ends up with L1 and L2 as levels. Names Default To Here( 1 );
levels = List(1,2,3);
d = DOE(
Custom Design,
Add factor(Discrete Numeric, levels)
);
d << Make...
Hello Community!Attached is the script "Hogi chart calculates risk and probability", an excellent work by HOGI ... which calculates the risks and probabilities of occurrence of an input or multiple inputs (x), of an output or multiple outputs (Y) or their combination in a table. For example:Would it be possible to expand the capacity of the script to make a sensitivity analysis of the inputs (x) o...
Hi There
Some time ago, I created a nice interface using Application Builder and I saved it as a journal. Now I need to make a few modifications to the interface, rearrange buttons, add boxes, and so on. I am unable to import the journal into the app and have the interface appear in the Module tab. It is a very busy interface ...Is there a way to have it?
Thanks
When I open a data table, I get a cycle detected error that I have to ignore every time. I can't seem to figure out what is causing the error although it apparently has something to do with the table variable in my column formula. Here is the formula: and here is the log entry showing the issue Can anyone help me understand what is going on here? The data table actually works fine after I click ...
Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...
(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...
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...