Welcome to the JMP User Community!

Latest Discussions

• Writing Excel formula in JSL script (Formula in attached excel file)

  Hi,I am trying to replicate formulas that are currently in the attached excel sheet.Where, DSA_Step_Size(dB) = ABS(of delta of :RESULT rows when ATT1 values are decreasing for the same :FREQUENCY value).The formula is in excel sheet if my explanation is confusing. DSA Range(dB) = ABS(of delta of :RESULT rows when ATT1=63 and ATT1=0 for each :FREQUENCY). I am trying to use for loops in the formula....

  LearningJMP

  Discussions |

  Aug 18, 2022 6:17 PM

  1775 views | 2 replies

• select a row then reselect Scriptiing

  In this sample table, I am trying to select the row that has a value of 2 in :Number, grab the value "A" from :Letter, then select all the rows contains "A" in :Letter. I wrote this script but it is not working. dt= current datatable(); dt <<select where (:"Number" == 2); s=Column(dt, "Letter")<<get Values; show (s); dt<<select where(contains(s,:"Letter"));looking at the log s = {"A", "A", "A",...

  GroupSquareWolf

  Discussions |

  Aug 18, 2022 10:29 AM

  1178 views | 2 replies

• Is there a way for a button box to "know" its location within a container box?

  Hi.  I'm wondering if there's a convenient method for a button box to somehow know where it lies within a lineup box.  My specifics: JMP Pro 16.2.0macOS Monterey 12.5 I have a script that creates a window with a LineUp box.  In each cell, there's a button box that I want to perform a different action, based on which column the button appears in.  For example: Names Default to Here(1); list = {"ca...

  nikles

  Discussions |

  Aug 18, 2022 9:54 AM

  2279 views | 4 replies

• How to get names of the selected columns in string format

  In my script I use the following to get the list of all columns in a string format:columnNames = dt << Get Column Names( string );I need that so I could iterate through them using "For Each" loop:For Each( {columnName, index}, columnNames, Column( dt, columnName ) << Set Name( columnName ||"SomethingHere" ) );Now I need to only get selected columns and run the same loop on them.I know only one way...

  miguello

  Discussions |

  Aug 18, 2022 8:27 AM

  4030 views | 5 replies

• Contour map creation in JSL brings up MIN/MAX/#LAYERS diaglog for each graph

  directory = "C:\TEST\"; fileNames = Files In Directory( directory ); For( iFile = 1, iFile <= N Items( fileNames ), iFile++, filename = fileNames[iFile]; If( Ends With( filename, ".csv" ), dt = Open( directory || filename ); max = Col Max(Column( dt,4)); min = Col Min(Column( dt,4)); dt:DC_0VDC << Format( "Engineering", 12 ); dt:DC_1VDC << Format( "Engineering", 12 ); dt:DC_3VDC ...

  ChesterKnurek

  Discussions |

  Aug 18, 2022 7:33 AM

  1432 views | 2 replies