Join tables with like method (contains)
hey, is it possible to join tables not with equal sign (=) but with like method (%) or something similar? for example: in one table I have column of names, in the second table I have column of parts...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourceshey, is it possible to join tables not with equal sign (=) but with like method (%) or something similar? for example: in one table I have column of names, in the second table I have column of parts...
...lder discussions about this problem. However, these solutions didn't work for me as a second column 'reactor number' could not be matched for. Here is a screenshot of the two data tables I would l...
Hi, If possible I would like extract particular text from the strings: \\swirt.misc@CAS-K-CLERK\K10447-Wit_OG lo hi TT-YYT (CTL1083.1)_172-7-10053 -303 \\swirt.misc@CAS-K-CLERK\K10445-Wit_OG lo hi...
Dear Community, For the process performance reports my colleagues and I create via JMP, we include a Levey Jennings control chart figure. We create this figure using the "Analyze"->"Quality and Pr...
...ilter? (Each product in my data has different spec values, different target values etc...) Any ideas on how to do this in a simple way would be great and appreciated. I could script it, but if there's a...
hey, is it possible to join tables not with equal sign (=) but with like method (%) or something similar? for example: in one table I have column of names, in the second table I have column of parts...
Dear Community, For the process performance reports my colleagues and I create via JMP, we include a Levey Jennings control chart figure. We create this figure using the "Analyze"->"Quality and Pr...
I have a lot of data (> 6,000) in one column for many different products. In another column I have product name and, in total, 12 different products covering these > 6,000 data. In graph build...
I have the following column, which contains string of char, such as dot or char (no number and special char). I want to generate a column that list out the position of the char which is not a dot. S...
I have a trouble with JMP16, hopefully someone has encountered and overcome this problem. While choosing commands, Cast selected columns into roles in Multivariate and correlations, the selecte...
I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function o...
I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar ...
Hi, I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've alr...
I am fitting a model of a continuous response against 7 fixed effects. When running the Standard Least Squares; my residuals plots/assumptions checks don't look too bad but the Durbin Watson test is ...
Hi, I want to export the prediction formula generated by Functional Data Explorer either to Excel or Python (via Formula Depot), but there is a problem because the formula contains P Spline Coef() i...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn to fit models using variable sel...
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...