About bjbreitling

bjbreitling · ‎08-13-2020

Hi Paul, How do you actually see anything you wubmit to python in python from a JSL file? I dont have any experience doing this but when I send x1 as the example you have and I go to a python scripting window x1 isn't stored. Do you have some kind of step by step documentation on this?

bjbreitling · ‎08-12-2020

I had uninstalled the anaconda before reinstalling it after it didnt help so I had only one copy at some point. Heres what I get from the log when I run the following: Names Default To Here( 1 ); Python Init(); version = Python Get Version(); Show( version ); Python Term(); LOG: /*: version = {3, 8, 5, "final", 0}; 0 //:*/

bjbreitling · ‎08-12-2020

It was saying I had a 32-bit version of python as an error when running the script so I uninstalled that version and re-installed a 64-bit version. I also have a separate anaconda installation as well. I don't get that error anymore but it doesn't see those packages that I have installed apparently.

bjbreitling · ‎08-12-2020

/**********/ # Import the numpy module for array and matrix support import numpy as _JMPnp /**********/ /**********/ # Import the scipy module for scientific computing support import scipy as _JMPsp /**********/ Here is the JMP log of the script. I have installed all of these packages in my 64 bit python site-packages folder. /**********/ # Import the pandas module for Series/Data Frame support import pandas as _JMPpd /**********/ Unable to import the 'numpy' Python module Unable to import the 'scipy' Python module Unable to import the 'pandas' Python module

bjbreitling · ‎08-07-2020

This is what the log says: /**********/ # Import the numpy module for array and matrix support import numpy as _JMPnp /**********/ /**********/ # Import the scipy module for scientific computing support import scipy as _JMPsp /**********/ /**********/ # Import the pandas module for Series/Data Frame support import pandas as _JMPpd /**********/ Unable to import the 'numpy' Python module Unable to import the 'scipy' Python module Unable to import the 'pandas' Python module /**********/ print (dt) /**********/ 0

bjbreitling · ‎08-06-2020

/**********/ # Import the numpy module for array and matrix support import numpy as _JMPnp /**********/ /**********/ # Import the scipy module for scientific computing support import scipy as _JMPsp /**********/ /**********/ # Import the pandas module for Series/Data Frame support import pandas as _JMPpd /**********/ Unable to import the 'numpy' Python module Unable to import the 'scipy' Python module Unable to import the 'pandas' Python module

bjbreitling · ‎08-06-2020

The above is some code I got from JMP documentation but when I run it nothing happens. I have 64-bit version of python 3.8 and JMP Pro 15. Can anyone help me with this? Do I need to add numpy and scipy and pandas? I have those in my python downloads. Do I need to put them in a different folder too for JMP to query?

bjbreitling · ‎10-08-2018

Hi I know you can join tables with JMP. How would I do a join between. In SQL server its something like SELECT * FROM [L].[dbo].[P] P INNER JOIN [L].[dbo].[FPD] FPD ON P.[Join Date] BETWEEN FPD.[BeginDate] and FPD.[EndDate] The script builder gives me code like the below with what EQ probably stands for equals. THe between part I added and am trying to figure out the correct way if possible to do in JMP so I don't have to load these tables into sql. From( Table( "pH Kinetics", Alias( "t1" ) ), Table( "New Dataset for Analysis Final 6", Alias( "t2" ), Join( Type( Left Outer ), EQ( Column( "Ferm", "t2" ), Column( "FERM", "t1" ) ) & EQ( Column( "Plant", "t2" ), Column( "Plant", "t1" ) )& Between( Column( "Time", "t2" ), Column( "BeginTime", "t1" ), Column( "EndTime", "t1" ) ) )

bjbreitling · ‎12-13-2017

I have it set up so that a few specific columns are called out for the user to suspect with the data filter. I also have a graph builder window open. The user is supposed to select points in the charts that they think are outliers. It would be nice to have a hide and exclude button in the data filter window to hide these selected points. It would also be nice to have a button in the data filter window to close the data filter window. These are mostly just to help with the user friendliness of the jump add-in as the users aren't very familiar with how or were to look to do things in up like hide and exclude selected points.

bjbreitling · ‎12-13-2017

Hi, Could anyone help me with the code to make an addin that creates a button that when clicked hides and excludes selected data. It can be in its own window but I would just like to add it to the bottom of a data filter box so that would be even better if someone could help me with the code to make a button that can do this that I could just append to the bottom of this JSL code for a datafilter window. Current Data Table() << Data Filter( Location( {812, 364} ), Mode( Show( 1 ), Include( 1 ) ), Add Filter( columns( :Name( "EQID(RUNS)" ), :RUN_FINISHED_DT, :Name( "MATCODE(INVENTORY)" ), :ANALYTE ), Where( :Name( "MATCODE(INVENTORY)" ) == "QC BPX V" ), Display( :Name( "EQID(RUNS)" ), Size( 97, 130 ), Check Box Display ), Display( :ANALYTE, Single Category Display ) ) )

bjbreitling · ‎10-16-2015

Double click in the table on the column you want to change. Then change the format to scientific and change the width to the number of significant figures in the calculation.

bjbreitling · ‎10-12-2015

I have a multiple linear regression fit that has an actual by predicted plot that looks like this: Actual by Predicted Plot What can I do with it to get a better fit as there appears to be a bias from standard regression. Is there away to due multiple orthogonal regression in JMP or SAS and if so how? Is there another technique in JMP I can use to address this? The model is only main effects.

bjbreitling · ‎08-25-2014

Hi Community, I have a calculation that I am putting from excel into a formula in JMP. That formula requires variables from 3 separate tables to work. One of the tables has the data, the other has the min and mas of the columns and is generated by a script. The third is just a table of weights but has no ties to the other two tables but I have just created the JSL which saves it. Can a formula script be made that would pull from all 3 tables? Any help would be appreciated. Maybe I need to use something like global variables and if so how do I set those with a script? This is for a jmp addin button that will create a column. Regards,

bjbreitling · ‎08-07-2014

Hi Byron, When I copy and paste the query into a script which is exactly the following: dt=CurrentDataTable(); dt<<Select Where(Exclude=="Exclude")<<hide<<Exclude; It works. But when I save the script to a jsl addin, it oddly doesn't. The column name and case and spaces match. So does it for the rows. Its very odd that it works in non-addin jsl but not in addin. I didn't generate this jsl form the data filter.

bjbreitling · ‎08-07-2014

That is an option PMroz, but I would prefer pulling the all the data and leave folks the option to un-exclude.

bjbreitling · ‎08-07-2014

Same issue PMroz. Oddly it still doesn't work.

bjbreitling · ‎08-06-2014

Hi Byron, That didn't fix it. I also made a separate addin that should work given what you said is true which I execute after the loading of the dataset which is just the following. dt=CurrentDataTable(); dt<<Select Where(Exclude=="Exclude")<<hide<<Exclude; This oddly doesn't work either.

bjbreitling · ‎08-05-2014

Hi community, When I open a table with a database with the following script saved to the datatable it works. When I save the script to a menu item in an addin it just pulls the data and doesn't exclude. Whats up? Open Database( "DSN=PI SQL Connection Lab;Description=PI SQL Connection Lab;UID=;Trusted_Connection=Yes;APP=JMP;WSID=SFX-5GCN2M1;DATABASE=LabData", "SELECT * FROM dbo.NSI_Discovered_Factors_Lab_Data", "NSI_Discovered_Factors_Lab_Data", "NSI Database" ); dt=CurrentDataTable(); dt<<Select Where(Exclude=="Exclude")<<hide<<Exclude;

bjbreitling · ‎07-08-2014

Hi Community, If I subset selected rows and selected columns I get the selected columns and selected rows. Is there away to get all the columns (selected or not) and only the selected row? I have a button in a script for users to subset data with that's highlighted/selected, but they often will have clicked columns inadvertently and then don't subset the whole data table but only the selected columns (not there desire but the JMP code is built that way). Below is the JSL for my subset button so if anyone can work within that code to get the desired that would be appreciated. Regards, tbl = Current Data Table(); runSubsetScript = Function( {df,tbl}, wc = df << Get Where Clause; Eval( Substitute( Expr( tbl << Subset( whereClause, ) ), Expr(whereClause),Parse(wc) ) ); ); newWind = New Window( "Data Filter Example", df = tbl << Data Filter( Location( {58, 58} ), Mode( Show( 1 ), Include( 1 ) ), Add Filter( Columns( :Timestamp,:Plant ), Display( :Timestamp,:Plant ) ) ), Button Box("Subset",runSubsetScript(df,tbl)) );

bjbreitling · ‎06-18-2014

SendToReport( Dispatch( {}, "102", ScaleBox, {Format( "Fixed Dec", 12, 0 )} ) ) The above works. The Dispatch code above being the change when you save script with the manual change of the format to no decimals in the chart. Before I had replaced the Dispatch code for the frame box that came with the script that was generated pre-change of the format manually. I changed everything but the place where the "102" was "Chart Value" and I never changed that and didn't realize that was important to change too.

bjbreitling · ‎06-17-2014

Hi Community, I have a frameBox and it doesn't respond to the code to change the format like the ScaleBox does i.e. , {Format( "Fixed Dec", 12, 0 )}. How would I change the format in a frameBox?

bjbreitling · ‎06-17-2014

How would I do that with a data table created with this code: combinedTbl = Report(fitModelPlt[1])["Effect?"][Table Box(1)] << Make Combined Data Table;

bjbreitling · ‎06-17-2014

How would I rename a table or name it period before it is created with a script. Below is the code for the table: combinedTbl = Report(fitModelPlt[1])["Effect?"][Table Box(1)] << Make Combined Data Table; Regards,

bjbreitling · ‎06-17-2014

Hi, I have a script with generates an additional datatable and an analysis. I would like the additional data table to be hidden after its generated but not closed as I want the analysis to be open. Is there a command in the script to do this? Regards,

bjbreitling · ‎06-11-2014

Is there a book or pdf out there more than the blurb in scripting guide?

bjbreitling · ‎06-10-2014

How would I exclude data that I have selected in application builder? I select the data in application builder, now is there a button to exclude what is selected and how would I code it?

bjbreitling · ‎06-10-2014

Basically, load an application that allows you to use data filter to sort through data and then use a button to make a subset of what is highlighted.

bjbreitling · ‎06-10-2014

Hi, I would like to create a new datatable from the sorted data of application builder. Basically sort through the dataset to find what you want and then hit a button that generates a new datatable for another JMP application to work with. Basically, load an application that allows you to use data filter to sort through data and then use a button to make a subset of what is highlighted.

bjbreitling · ‎06-09-2014

Hi community, I have a data filter application that I would like to do variable selection in. The problem is that If I do something like step-wise regression model dialog report and put it in the data filter content box the same as the data filter and sort with the data filter, when I run the variable selection it opens a new window out side of the application and the data filtering no longer applies. Is there anyway to keep the step-wise regression and have it stay in the application?

bjbreitling · ‎06-09-2014

Sorry. I can just use the data filter and data filter content box. Is there anyway I can pre-specify one of the columns in the data filter? Basically get to the screen where if you like you can add with "and" or "or". That would make it even easier as I know the column I want folks to look at first.

Date Registered	‎12-13-2012 04:51 PM
Date Last Visited	‎08-13-2020 09:19 PM
Total Messages Posted	37
Total Kudos Received	2

Online Status	Offline
Date Last Visited	‎08-13-2020 09:19 PM