Welcome to the JMP User Community!

Latest Discussions

• split a column and create multiple multiple based on split using JSL

  Hello,  I need to read existing table and find the column of interest [say the column name is "data"]. the column "data" is numeric with "dot" delimited and have same length. My goal is to open this table, read column "data" , remove the "dot" and create new columns [as per the length of value] and each column holds each value. Orig table:data------123.56.8.342431.02.0.567318.00.1.816..... expecte...

  david_sam

  Discussions |

  Dec 31, 2020 9:20 PM

  3847 views | 5 replies

• JSL to summarize delta ranges in different column

  Hello, I have a data table that had 6 repeat test data set. I need to summarize index from each test but not sure how to do so: For each test, I need to summarize the time range (column 1) in between -0.5 to 0.5. For example for test 1, time between -0.5 to 0.5 is 12.Is this something doable in summary table or formula? What would be the right script for this? Any help is highly appreciated. Thank...

  yuedeng1015

  Discussions |

  Dec 30, 2020 9:55 AM

  1791 views | 2 replies

• Summarize function Date

  I pretty new to jmp and have been trying to gain as much knowledge as possible on the the scripting language.  I have been referencing both the scripting guide and the index if I run into any issues.  As far as the Summarize function is concerned,  is there somethin I am missing.... I am attempting to pull the min and max date and I am getting a rather large numerical value.As far as the formattin...

  dhurw

  Discussions |

  Dec 29, 2020 2:23 PM

  3995 views | 9 replies

• How do I ensure that my scalebox does not stay fixed in size

  I kindly need help in to create a JSL script that does not make my variability chart scalebox stay fixed in one size because I'm having problems to see any values when the value is outside my control limits. Below is an image how the chart looks like for a given script. Appreciate it if someone could advise me how to let it ensure all the points inside this chart Variability Chart( Y( :chart_valu...

  Danial1

  Discussions |

  Dec 29, 2020 7:59 AM

  2107 views | 3 replies

• Populating a new column using a conditional formula

  I am attempting to populate a new column ( :Prog_ ) with either "A" or "B" based upon the value of (:Assign Month).  :Assign Month is a numeric, continuous, m/d/y variable. The below script result in the :Prog_ column being populated but not with the values I am trying to populate the :Prog_ column with. I'd like to populate the :Prog_ column rows with an "A" if :Assign Month <= "06/15/2016"I'd li...

  dfusco923

  Discussions |

  Dec 28, 2020 7:43 PM

  4491 views | 5 replies