About mohamed_elhassa

mohamed_elhassa · ‎10-29-2018

Thanks @pmroz and @txnelson for the scripting help. To be more specific, what I am looking for is to use the check of whether or not the value of the first cell is in the list as the conditions for an if statement which will drive some other actions. I think that both of your scripts fill another array but they're not a strict T/F. I will try to use them and let you know what happens.

mohamed_elhassa · ‎10-26-2018

Given a data table with a column of limited values (se examples below), I would like to write a script that looks at the first cell and checks if it is in a list of values. The purpose would be to use whatever that first value as the conditoin for an IF statement that would then point to a certain set of tasks. Anyone have an idea how to do this? thanks e.g. CAT time A 1 B 2 C 3 D 4 E 5 or CAT time V 1 W 2 X 3 Y 4 Z 5

mohamed_elhassa · ‎10-23-2018

Sorry for the late response ... using the dt:colname helped to clear up the original issue! Thanks so much for the help.

mohamed_elhassa · ‎10-11-2018

Script joins multiple tables (summarized from an original table) and then I try to clean up the column names. The log informs that the error is in this line: :Name( "HT_par_50p subch" ) << set name( "HT par subch" ); but in the log it shows the error location (/*###*/) at: :HTBar_par_50p subch/*###*/ << set name("HT par subch"); which is a line from the previous version of the code. I have "Names Default to Here(1)" at the very top of the script to ensure that no previous runs should interfere. I've tried adding "Delete Symbols()" but the script still stops in the same place. Any ideas what could be happening and how I can stop it?

mohamed_elhassa · ‎06-27-2018

The code works great! Thanks for the help

mohamed_elhassa · ‎06-25-2018

Here's a variation on the original request: what if you want to add different values into the empty cells. For example you have the table below, and you want to put C in the third cell, A in the fifth cell, and D in the 8th cell. is there a way to that programmatically? I had initially thought that an easy way to do it would be to add rows and fill them in with all the known letters to ensure we had all of them represented. 33 A 12 B 15 1 D 7 22 B 9 C 28

mohamed_elhassa · ‎06-21-2018

Has anyone run into the case where you import data and one or more columns show no data in JMP? I'd appreciate any insights. I've been using this script (with identifying features removed of course): Open( "C:\My documents\excelly.xlsx", Worksheets( "DATASTUFF" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 1 ), Data Starts on Row( 2 ), Data Starts on Column( 1 ), Data Ends on Row( 0 ), Data Ends on Column( 0 ), Replicated Spanned Rows( 1 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ) ) );

mohamed_elhassa · ‎03-01-2017

Thanks for the assistance fellows! I found the show limits(1) does work but it needs to be INSIDE the curly brackets like so: Set Property( "Spec Limits", {LSL( 125 ), USL( 127 ), Target( 126 ), Show Limits( 1 )} ) )

mohamed_elhassa · ‎02-28-2017

How'd you do that? Would you mind sending out the code? Does it work for JMP 12 too? thank you M

mohamed_elhassa · ‎02-28-2017

I have recently updated to JMP 12.1 and was trying to port over an old script to set the spec limit property (see below). It works fine in JMP 11, but now that I'm running JMP 12.1, the code in red doesn't work. It doesn't error out, it just doesn't toggle the option for showing specs as graph reference lines. Has anyone found a solution to this? M JMP 11 code that worked but doesn't work with 12.1 dt << Sort (By("Date"), Order (Ascending), Replace Table); Column ("Width") << Set Property("Spec Limits", {LSL(1.7), Target(1.9), USL(2.1)}, Show as graph reference lines( 1 ), );

Date Registered	‎11-24-2015 05:10 PM
Date Last Visited	‎10-30-2018 03:51 PM
Total Messages Posted	10

Online Status	Offline
Date Last Visited	‎10-30-2018 03:51 PM

Re: JSL script to check if a single cell value is in a list

JSL script to check if a single cell value is in a list

Re: JSL code hanging up at a column name change

JSL code hanging up at a column name change

Re: Filling empty cells in a specific “character” column

Re: Filling empty cells in a specific “character” column

Import (open) data from excel: data columns empty

Re: JSL - showing spec limits as graph reference lines (JMP 12)

Re: JSL - showing spec limits as graph reference lines

JSL - showing spec limits as graph reference lines (JMP 12)

Re: Hide and exclude rows in data table if criteria is met in one column

Re: JSL - showing spec limits as graph reference lines (JMP 12)

Re: JSL script to check if a single cell value is in a list

JSL script to check if a single cell value is in a list

Re: JSL code hanging up at a column name change

JSL code hanging up at a column name change

Re: Filling empty cells in a specific “character” column

Re: Filling empty cells in a specific “character” column

Import (open) data from excel: data columns empty

Re: JSL - showing spec limits as graph reference lines (JMP 12)

Re: JSL - showing spec limits as graph reference lines

JSL - showing spec limits as graph reference lines (JMP 12)