About thomasz

thomasz · ‎11-29-2019

Please add a columns filter for the columns in the main table view. Also add the filter as default to all column selectors (or as an optional preference)

thomasz · ‎08-21-2018

Probably a bit late, but I found the post looking for setting the kernel value. Here is a solution for creating a reproducible smooth fit with adjusted bandwidth in case somebody looks for it again. I hope though that the Jmp team improves on that... dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dst=Distribution( Automatic Recalc( 1 ), Continuous Distribution( Column( :height ), Vertical( 0 ), Fit Distribution( Smooth Curve ), Confidence Interval( 0.95 ) ), Histograms Only ); dstr=dst<<Report; dstr[Sliderbox(1)]<<set value(0.7); npd=dstr[OutlineBox(3)]<<Get Scriptable Object; npd<<Quantiles( 0.00135, 0.99865 );

thomasz · ‎08-21-2018

Is there a bugtracker for JMP or another place for posting bugs?

thomasz · ‎03-17-2018

Thanks for your reply. I realized afterwards there are some other problems like x cannot be local, but this can be fixed. But I couldn't figure out how to pass a column reference in the function call. I had a similar problem some time ago and solved it passing column names as strings. As in the example below that works: names default to here(1); Add Custom Functions( {New Custom Function( "NNE", "N Categories", Function( {Categories, ByColumn},{Default local}, If( Row() == 1, Summarize( here:x = by( column(ByColumn), column(Categories) ) ); ); N Items( Loc( here:x[1], column(ByColumn)[row()] ) ); ), <<Description( "Determine number of unique categories of a column by/within each By Column" ), <<Prototype( "N Categories( :Categories, :By column )" ), <<Formula Category( "NNE" ), <<Scripting Index Category( "" ), <<Result Type( {"Any"} ), <<Parameter( {"String"}, "Category Column name" ), <<Parameter( {"String"}, "By Column name" ), <<Example(expr(dt = Open( "$SAMPLE_DATA/Air Traffic.jmp" ); dt<<new column("Different Airlines at Airport",formula(NNE:N Categories("Airline","Airport"))); )); )} ); It can be called like this in a column formula: But it requires strings instead of column references. I can rephrase my question: Is it somehow possible to change the above so that the N Categories function accepts column references instead of strings?

thomasz · ‎03-16-2018

The download links do not work

thomasz · ‎03-16-2018

Having this table: New Table( "test table", Add Rows( 9 ), New Column( "By column", Character( 1 ), "Nominal", Set Selected, Set Values( {"a", "a", "a", "b", "b", "b", "c", "c", "c"} ) ), New Column( "Categories", Character( 1 ), "Nominal", Set Values( {"t", "t", "r", "y", "t", "r", "r", "r", "r"} ) ), New Column( "N Categories", Expression, "None", Formula( If( Row() == 1, Summarize( x = by( :By column, :Categories ) ), Empty() ); N Items( Loc( x[1], :By column ) ); ), Set Display Width( 109 ) ), Set Row States( [1, 0, 0, 0, 0, 0, 0, 0, 0] ) ) I would like to create a custom function doing the same thing as the formula in the N Categories column. Converting it into a custom function script in the formula editor gives me something like this: Add Custom Functions( {New Custom Function( "custom", "N Categories", Function( {Categories,By column}, {Default Local}, If( Row() == 1, Summarize( x = by( By column, Categories ) ), Empty() ); N Items( Loc( x[1], By column ) ); ), <<Description( "" ), <<Prototype( "" ), <<Formula Category( "" ), <<Scripting Index Category( "" ), <<Result Type( {"Any"} ), <<Parameter( {"Any"}, "" ), <<Parameter( {"Any"}, "" ) )} ); But now the parameters, prior being column references just become parameters containing the values of the rows. So my question is: Is it possible to create a custom function that treats the parameters as column references? I could make it work by treating the parameters as column names and transfer strings instead, but it would not be the same!

thomasz · ‎03-09-2018

Enable breaking in row state handlers to make the Jmp debugger useful when scripting applications.

thomasz · ‎03-07-2018

An old question, but why not just setting rs=0 ?

thomasz · ‎02-27-2018

Do you mean like this? nw = New Window("Reports", <<Journal, hlb = V List Box( tb1 = Text Box( "Zone1:Cpk<1.33 && DSA>1.5" ) , tb2 = Text Box( "Zone2:Cpk<1.33 && DSA<1.5" ) , tb3 = Text Box( "Zone3:Cpk>1.33 && DSA>1.5" ) , tb4 = Text Box( "Zone4:Cpk>1.33 && DSA<1.5" ) , ); );

thomasz · ‎02-22-2018

Not a very elegant solution, but something like this may work: lv={}; for(i=1,i<=4,i++, insert into(lv,"")); tCB=""; for(j=1,j<6,j++,tCB||="check box( (lv)),"); tCB=substr(tcB,1,length(tCB)-1); eval(parse(eval insert("wind=new window( \!"Check boxes\!", H List Box( ^tCB^))")));

thomasz · ‎02-22-2018

Thanks for your reply I think this will only work if the sentence ends with the capitals and you need the capitalized term. The solutions I ended up with was to remove all capitalized terms with the following formula: Regex( :Text, "(?:\b[A-Z]{3,4}\b)", "", GLOBALREPLACE ) It basically works as a search-replace with the GLOBALREPLACE option.

thomasz · ‎02-22-2018

It is possible to overlay the two contours, but unfortunately I couldn't find a way to change colors and transparencey to make it look nice... Right click one of the countours and choose edit->Copy frame contents then on the other: edit->paste frame contents. And make sure both are within the axis scales.

thomasz · ‎02-21-2018

I might have found the answer myself, as the manual says step 1 is to convert everything to lowercase... Would it be a problem to change that to step 2?

thomasz · ‎02-21-2018

Is it possible to match only capital letters in Text explorer's customize regex patterns? I am trying to match only initials which are typically 3 to four letter capitals.

thomasz · ‎02-21-2018

Hi Reinaldo Are you aware of this article: http://www.jmp.com/support/notes/30/584.html? Kind regards, Thomas

thomasz · ‎02-21-2018

You can do it in three steps by hand: Select the columns Choose standardize attributes and then recode. Recode all .'s to 0. If you want to do it by jsl, you could do it like this: dt=current data table(); colnames = dt << get column names( numeric,string ); For( i = 1, i <= N Items( colnames ), i++, column(dt,colnames[i])[dt<<get rows where(is missing(as column(dt,colnames[i])))]=0; ); Kind regards, Thomas

thomasz · ‎02-21-2018

Hi Zvika Possibly the Life distribution platform is what you are looking for. Have a look at: https://www.jmp.com/support/help/13-2/Example_of_the_Life_Distribution_Platform.shtml Kind Regards, Thomas

thomasz · ‎02-21-2018

Thanks for the reply, Craige I am familiar with regex'es and already use the regex rules in text explorer for a many things. Good idea with the * suffix. What I was hoping for is, that the stemming rules are stored in some script language or that it is possible to write an extension. I believe if this is not possible, then using Snowball in a script could be an option: http://snowballstem.org/ Or even better, if snowball could be integrated directly in the text explorer platform, e.g. by providing an option to use Snowball if it is installed, would be great 🙂

thomasz · ‎02-21-2018

Is it somehow possible to extend stemming rules in text explorer platform with a new language, e.g. Danish? Kind regards, Thomas

thomasz · ‎02-14-2018

Level: Advanced Thomas Zelikman, Senior Consultant, NNE An industrial setup is presented, where JMP was used to import and join files from several different temporal data sources, including vibration measurements, machine operation data and video files. With JSL in JMP, it was possible to create a script that performs all necessary conversions and preconditioning of data such as extraction of sound from video files, spectral analysis of sound and vibration and synchronization of temporal data with geometrical measurement positions on the specimens produced in the process to enable linking process events with measurements on the output. Multivariate methods were used to create a prediction of the output suitable for exporting predictor expression to the controller. Design of experiments methods were used to identify how the output should be affected to close the control loop and obtain the desired response.

thomasz · ‎02-09-2018

Provide a builtin "Recall" message to all objects created by the New Window function. The Recall message should traverse the whole display tree and revert the state of all display boxes to the last state recorded state when the window was closed last time or when a "Store Window State" message was sent. The exact behaviour should be configurable when constructing the window. The behaviour should mimic the behaviour of Recall functionality in the platforms with a minimum of coding effort.

thomasz · ‎02-02-2018

The command "Create Excel Workbook" shifts colors of colored cells by one line when exporting to an Excel workbook. Tried in JMP 13 and 14 EA and it fails to do it correctly. Any workarounds apart from coloring the wrong cells or omitting cell colors? I also found that the close command does save colors correctly when saving in Excel format, but I did not find any way to save multiple sheets into one Workbook. Can it be done?

thomasz · ‎02-02-2018

Hi, when trying to journal a table, containing multiple lines, the table is not displayed correctly in the journal (tried Jmp 13 and 14EA). E.g: This: Becomes: Is there some way to fix that ??? Kind regards, Thomas

thomasz · ‎02-01-2018

The JMP Wish list seems like a good idea and has existed more than half a year by now. According to the stats ZERO ideas have been approved for implementation. I suggest you start using the JMP Wish list actively.

thomasz · ‎01-31-2018

One way to do it: fm=Fit Model( Y( :Time 1, :Time 2 ), Effects( :Cell Type, :Treatment, :Prior, :Age, :Diag Time, :KPS ), Personality( "Generalized Regression" ), Generalized Distribution( "Weibull" ), Run( Fit( Estimation Method( Maximum Likelihood ), Validation Method( None ) ), Fit( Estimation Method( Lasso( Adaptive ) ), Validation Method( AICc ) ) ), SendToReport( Dispatch( {}, "Maximum Likelihood", OutlineBox, {Close( 1 )} ) ) ); fmr=fm<<report; fmr[OutlineBox(7)][TableBox(1)]<<Make combined data table;

thomasz · ‎12-20-2017

Instead of the dreaded ###, please show which file and line number a script failed in. Kind regards Thomas

thomasz · ‎11-01-2017

Dear Scott I guess, now I understand what you are looking for. In some platforms you can simply save the profiler formula or the data grid, but not in this platform. A way could possibly be to change each coordinate sequentially and record the probability of Warning value for each, but as there a 6 dimensions, a grid with just 10 values will give you 10^6 combinations, so it is a dull path to go, and there is no guarantee for a usable result. Probably finding out the math behind and doing the calculations would be more feasible. Hopefully somebody comes up with a better solution. Kind regards, Thomas

thomasz · ‎10-27-2017

Hi Brian It's on windows and I tried up to Jmp 14 EA7. All Jmp versions know to me on Windows are affected. Thanks for the info about explicitly typing the column in Excel. Maybe it will be handy somewhere, but that solution requires that the Excel file is modified which is not always possible. In case it is difficult to estimate the correct date format, a simple solution could be to make it possible to explicity specify the format (including date format) for each column in JMP. In many situations the format is known, so Jmp wouldn't have to guess the format. Jmp could also choose to scan more than one row before determining the date format. It would not be bullet-proof, but combined with using the correct Windows locale settings as a first guess if both formats are possible, it would be an improvement.

thomasz · ‎10-27-2017

When importing an Excel table with scientific or percentage formatting, Jmp drops decimals that are not displayed in the format. When formatted as a number - or even a fraction, all decimals are imported correctly. Also, importing dates does not work when the date format is in dd-mm-yyyy format and Jmp finds a date in the first row that could fit into the mm-dd-yyyy format. Jmp simply delete all dates that do not fit the mm-dd-yyyy format. Here is an example: Excel file: File imported in Jmp: Decimals for percentage and scientific formats are lost during import (changing format does not help...) Forcing a text import is a workaround for the date issue when the data file contains column names that can only be interpreted as text, but this workaround does not work for the number issue. Please fix both issues!

thomasz · ‎10-27-2017

You could open the source property of your non-linked table, insert "link to original data table(1)" and rerun the script, but any edits before the table was linked will not be updated in the original table. Example: << Subset( link to original data table(1), // insert this line to the source script and run Selected Rows( 0 ),

Date Registered	‎03-11-2016 08:41 AM
Date Last Visited	‎04-19-2020 07:02 AM
Total Messages Posted	36
Total Kudos Received	43

Online Status	Offline
Date Last Visited	‎04-19-2020 07:02 AM