Problem You need to execute some JSL more than once. Solution Use a for(...) or while(...) or one of the more exotic variations. The for loop is the most common way to repeat some s...
Craige_Hales
Problem Suppose you prompt a user to make a selection. When you retrieve the values from the user, typically they are stored in a list. Now you need to select the data that matches the v...
Wendy_Murphrey
...toredCredential -Target $target $creds.GetNetworkCredential().UserName" ) ); You can delete these test credentials using the 'windows credential store'. Ideally these credentials would never be s...
ih
Problem You want to use a Slider Box to set a continuous value, and you want to see the current value as you move the slider. Solution Make a Slider Box and a Number Edit Box. Add a script ...
Craige_Hales
Problem You need to build a custom calculator that displays a table of numbers based on several input values. Solution Use Number Edit Boxes to get the values and use the Set Function metho...
Craige_Hales
We are in the process of revamping the JSL Cookbook to give it broader appeal, make it better organized, and easier to use. The focus will be on short projects (recipes) to help you improve your JSL....
DonMcCormack
...ccomplish the same thing. This blog post by @joseph_morgan has addition examples and insights into the same topic. Thank you @Justin_Chilton for feedback on this post.
ih
Problem You need to look at every element in an Associative Array Solution use the <<First and <<Next messages // load a table of elements dt = Open( "https://en.wikipedia.org/wiki/...
Craige_Hales
Problem Suppose your data table has a set of rows selected. Now, you want to select rows from that selection that meet an additional condition. Solution The Select Where() message for...
Wendy_Murphrey
Problem You have some code that you want to call from more than one place, maybe with different arguments. Solution Use a user written function, with parameters, local variables to keep the...
Craige_Hales
Problem You have data in a Matrix and need a Data Table, or the other way 'round Data table or matrix? Solution There is a function, AsTable(), that makes a new data table from a matrix, a...
Craige_Hales
...t the end, but it is probably a bad idea to do that to real source files. See Also Files-In-Directory concatenate-data-tables
Craige_Hales
Problem APIs and other machine generated code often delivers very complicated data structures. I found it helpful to have a tool that analyzes these structures and make them more accessible. Idea...
bernd_heinen
Problem REST interfaces are becoming more and more popular. Understanding this technique becomes very important for JSL programmers. Solution MapQuest uses this technique to provide i...
bernd_heinen
...ecessary information. See my blog post for more detailed information. See Also Geocoding 2020
bernd_heinen
...rovide the necessary information. See my blog post for more detailed information. See Also Geocoding 2020
bernd_heinen
Problem You have a 2D matrix. You used the Loc function to locate interesting elements, but Loc returned indexes for a 1D matrix. How can you convert the 1D indexes back to 2D indexes? Soluti...
Craige_Hales
Problem I wanted to create this figure for a publication Solution To create the vertically oriented shaded/filled and truncated normal curves, I utilized the Polygon() graphics f...
MathStatChem
Problem You know some C++ and have some idea what a C++ object is and need the 20 minute intro to JMP's scripting language. Solution There is a JMP scripting index on the Help m...
Craige_Hales
Problem If you need to open a file in an external program, typically the JSL Open() function will work for you. However, if you want to open a file type that JMP knows how to import, you will proba...
Justin_Chilton
Problem When creating user interfaces in JMP, you may want to add some background or foreground colors to your displays. However, with JMP 15's new support for macOS Dark Mode and Windows High Cont...
Justin_Chilton
Problem You have data in one or more lists or matrix vectors that you need to sort. Solution Use Sort List() or Sort List Into(), Rank(), or put the lists and vectors in a data table and sort it. ...
Craige_Hales
Problem Suppose you wish to select rows in a data table that meet more than one condition. Or, maybe you want to select the rows that meet one of a few conditions. Solution The ...
Wendy_Murphrey
...t;< Summary( Group( :sex ), Freq( "None" ), Weight( "None" ) ); //create a summary table of the :age column _dt2 = _dt << Summary( Group( :age ), Freq( "None" ), Weight( "N...
MathStatChem
Problem You need to automate adding reference lines to a chart. Solution Use JSL to run a summary on the data. Take the summary values and insert them into the graph builder script. /...
Craige_Hales
