Batch processes have different phases (e.g. loading, waiting, pre-heating, reaction, cooling, curing, unloading).   Dynamic time warping can be very tricky if you try to align all those phases at once. The alternative is not pleasant, as you have to create a model per phase.   As a record of these phases is available (in a separate column), it should be easier to pass this information to the FDE platform so the dynamic time warping algorithm knows what pieces need to be aligned.       ... View more

Gaussian Processes are a very powerful modeling technique in predictive analytics. https://scikit-learn.org/stable/modules/gaussian_process.html   While JMP has GP, it is only for specialized modeling (not possible to fit using training/validation/test)     ... View more

I have table I would like to format appropriately (attached as well) The main complexity comes from the following three problems: Users of this script will have different date formats as they will have different windows machines in different languages. For example, the database input for the column datetime is (always) in format dd-mon-yyyy hh:mm:ss which does not exist in Spanish or German languages.    2. Users will also have different number formats. All the columns will result in empty numeric values as it is expecting a comma for decimals (3.14 will not be recognized as 3,14).   3. After the first column, which is always a date-time, columns can contain numeric or categorical values. In the attached example, column3 contains comments so there is no change of format needed.   Potential solutions:   Problem #1 (date-time using locale) Perhaps the easier is to verify that JMP langague is in English, activate/deactivate  the option of ignoring the locale settings:   dt = Current Data Table(); // TODO assert that JMP language is English Preferences( Use JMP Locale Settings( 1 ) ); dt:datetime<< Set Data Type( Numeric ) << Modeling Type( continuous ) << Format( "Locale Date Time h:m:s" ); Preferences( Use JMP Locale Settings( 0 ) ); dt:datetime<< Format( "Locale Date Time h:m:s" ); Problem #2 To change the format from english to locale, we can do something similar. More info in this post https://community.jmp.com/t5/Martin-Demel-s-Blog/JMP-and-Excel-A-Never-ending-story-Part-2/ba-p/35099   dt = Current Data Table(); // TODO assert that JMP language is English Preferences( Use JMP Locale Settings( 1 ) ); dt:column1 << Set Data Type( Numeric ) << Modeling Type( continuous ); Preferences( Use JMP Locale Settings( 0 ) ); dt:column1 << Set Data Type( Numeric ) << Modeling Type( continuous ); Problem #3 How to code use the best guess from JMP so columns are only passed from characters to numeric?   Following this post: https://community.jmp.com/t5/Discussions/Convert-data-to-numeric-Only-If-Appropriate/td-p/106692 dt = CurrentDataTable(); // TODO Assert that JMP is in English Preferences( Use JMP Locale Settings( 1 ) ); // Convert to numeric only if nedeed For( i = 2, i <= N Cols( dt ), i++, isNumeric = "NO"; For( theRow = 1, theRow <= 10, theRow++, If( Column( i )[theRow] != "" & Is Missing( Num( Column( i )[theRow] ) ) == 1, isNumeric = "NO"; Break(); , isNumeric = "YES" ) ); If( isNumeric == "YES", Column( i ) << set data type( numeric ) << Modeling Type( continuous ); Preferences( Use JMP Locale Settings( 0 ) ); Column( i ) << set data type( numeric ) << Modeling Type( continuous ); Preferences( Use JMP Locale Settings( 1 ) ); ); ); Preferences( Use JMP Locale Settings( 0 ) );   I am missing the assertion that makes sure that JMP is in English and if there is a more efficient way to this (it might have 100,000 rows and hundreds of columns). ... View more

An .exe file within a loop returns a string a need to convert (efficiently) to a data table.   The string has the following characteristics:   Rows are limited by "\n" characters, although this can be changed if needed Columns are limited by "," The begging and the end of the string has rows one needs to eliminate The datetime rows can vary. In the example one can see 7 but these can go up to 100k rows. This operations will be repeated within the loop in the order of hundreds (different strings but same number of rows)     str_query = "*> mycolumnname 1,mycolumnname,50.,mycolumdescription,mycolumnunits * End exe... *> mycolumnname, 31-Jan-2020 14:30:00, 31-Jan-2020 15:30:00, blabla, 7 31-Jan-20 14:30:00,mycolumnname,10.60466 31-Jan-20 14:40:00,mycolumnname,10.60466 31-Jan-20 14:50:00,mycolumnname,10.60466 31-Jan-20 15:00:00,mycolumnname,10.60466 31-Jan-20 15:10:00,mycolumnname,10.60466 31-Jan-20 15:20:00,mycolumnname,10.60466 31-Jan-20 15:30:00,mycolumnname,10.60466 * End exe... ... ... ... ... ";     How can I transform this string into a data table with the following (stacked) format:   31-Jan-20 14:30:00,mycolumnname,10.60466,mycolumdescription,mycolumnunits 31-Jan-20 14:40:00,mycolumnname,10.60466,mycolumdescription,mycolumnunits 31-Jan-20 14:50:00,mycolumnname,10.60466,mycolumdescription,mycolumnunits 31-Jan-20 15:00:00,mycolumnname,10.60466,mycolumdescription,mycolumnunits 31-Jan-20 15:10:00,mycolumnname,10.60466,mycolumdescription,mycolumnunits 31-Jan-20 15:20:00,mycolumnname,10.60466,mycolumdescription,mycolumnunits 31-Jan-20 15:30:00,mycolumnname,10.60466,mycolumdescription,mycolumnunits Which JSL functions can manage these string to data table operations efficiently (memory and/or CPU wise?).   Multi-threading or multiprocessing cannot be used this is querying a database.         ... View more

How I can define a variable that is recorded in JMP, so next time I open it I still have access to it?   For example, global variables are defined as:   ::my_global_variable = 42;     ... View more

I would like to filter out certain frequencies in a time series data set. With the spectral density in Time Series  I can see the FFT and its peaks but I wonder if there is built-in filter to perform these type of DSP operations.   For example, with FFT() one can do the inverse to have a new signal with only the selected frequencies. ... View more

I am trying to call the the Menu Move Selected Columns from a GUI.   While this code calls it, it does not reorganize the table (probably due to the wrong usage of MoveSelectedColumns...)   MoveButtonPress=Function({this}, // colListData is a Filter Col Selector in a GUI selectedElements = colListData << GetSelected; DataTable1 << move selected columns(selectedElements, after()); // TODO fix this colListData << Reset; //refresh selector colListData << NameContains (" "); // reactivates filter );   ... View more