How to install a mySQL connector for use in a JMP 18 python program
What are the steps to install a Connector for use in the integrated Python in JMP 18. Specifically, I need to connect to a mySQL database.
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesWhat are the steps to install a Connector for use in the integrated Python in JMP 18. Specifically, I need to connect to a mySQL database.
I am connecting to a database using ODBC, which has a specific user and password created for that purpose (not possible to use windows Active Directory, or other).
When the query is built, the table script stores the user ID.
Password is asked but it can also be coded directly into the connecting string in JSL.
What are the best options to handle such situations in JSL?
JMP files may be shared but upd...
I have a raw data need to text to column with many special character, then stack them. Could you please help provide solution by JSL script for generic case. Please help to refer my excel file for detail
Hi,how could use jsl to get X axis Value by JSL?like oneway anovaI want to get first /second name in x-axisthanks
Hey everyone,I was wondering if someone could help me out with a script that I could assign to my toolbar so that I could "one click" turn graph builders "Fit to Window" options on and off So if it I clicked it and the current selection was "Auto/On/MAR" then it would set Fit to Window to "Off" and if the current section was "Off" then it would set Fit to Window to "On". Thanks for any input on ho...
Hi,how could use jsl to get X axis Value by JSL?like oneway anovaI want to get first /second name in x-axisthanks
Names Default To Here(1);
//Open Data Table: Recovery_Analysis:Plate Name.jmp
Recovery_Analysis:Plate Name = Open("MY FILEPATH");
//Split data table
Recovery_Analysis:Plate Name << Split(
Split By(:Chemistry),
Split(:Concentration),
Group(:Well Id),
Output Table("Untitled 17.jmp"),
Sort by Column Property
);
//Save data table: Recovery_Analysis:Plate Name.jmp
Recovery_Analysis:Plate Name...
I was trying to write a function to join dt2 to dt1, however, I cannot get it to work at all... The error I got is "Name Unresolved: TrimTable at row 1 in access or evaluation of 'TrimTable' , TrimTable( dt1[1] ) /*###*/"
What is wrong?
Much appreciated for the help!
join_data_table = Function({dt1, dt2},
{Default Local},
dt_1 = TrimTable(dt1[1]);
dt_2 = TrimTable(dt2[1]);
dt_1 << Join(
...
Hi, i have a several charts created in a new window, i want to have a "refresh button" that will refresh specific chart in the same place (if for example i filtered some data), for now all i got that it adds the cart under the original and if i delete the original before it gives an error
Hi, I am new to programming in general and am having trouble with this one column in JMP. I want to create a new column from one that is autogenerated, but my if/ then statements aren't working. I think its because sometimes there are words and spaces within the strings of numbers and often dashes and periods. I am looking for only one number within a string of numbers. Sometimes it will be at the...
(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...
I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...
Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer(
Text Columns( :col1)
);
obj << Stemming("Stem for Combining");
obj << Add Recodes(
{{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...
Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads Kindly guide. Thanks in advance
Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...
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...