Welcome to the JMP User Community!

Latest Discussions

• How to create a data table of 3 columns per row from numeric string

  I'm new to JSL. I have a text string that contains values separated by a "#". The numbers are to be grouped in 3 columnsI know I can write a code to put the values in columns being separated by the "#", but how do I then create a table of 3 values in each row, until the table is complete. I know I'll also probably need to remove the first "#" to prevent issues as first 3 numbers would be in 2nd to...

  godriscoll

  Discussions |

  Mar 22, 2024 5:14 AM

  1556 views | 2 replies

• sumif: count columns if they contain some character

  Hello,I found a discussion from 2015 (subject "sumif") that has a very helpful script for my current task.I wrote there my question but I don't know if people who participated in that discussion can see my question. This script I found (slightly modified) and it works great for counting columns for each row where values are "0/0" (or whatever).dt << New Column("Sum", Numeric, Formula( ...

  Valentina

  Discussions |

  Mar 22, 2024 3:27 AM

  2544 views | 7 replies

• How to use Set Property() to make a custerm order for a column?

  Hi, Dears,I have a Demo.jmp which includes 3 columns:Column Name, Data TypeT, CharacterValue,NumericSN,Characer I'd like to make a custerm order on column "T" as "LT","RT","HT" ascending with the script below://dt = Open("Demo.jmp"); //please open Demo.jmp manually dt = Current Data Table(); dt << Recode Column( :T, Update Properties( 1 ), Target Column( :T )); :T <<Set Property( "Value Order",{"...

  AutoDormouse960

  Discussions |

  Mar 22, 2024 12:40 AM

  1028 views | 1 replies

• How to write wait time in JSL as a numeric display of seconds?

  Specific point: I set the countdown for 20 seconds, and when there are still 5 seconds left, a window will pop up to show the remaining number of seconds, and the displayed number will be reduced by second, and the countdown window will automatically close Wait(20);Thanks!

  lala

  Discussions |

  Mar 22, 2024 12:27 AM

  1055 views | 2 replies

• Fill column once per group without repeating values with JSL

  Hi!So I have the below data table.  The individual test results are in the "test result" column and indicate if the respective y passes test a,b, and c. The "overall result" column indicates a "pass" if 2 or more of the tests (a,b,c) pass. I was able compute the overall result with a formula, but what I would like to do is get a list that says the result once per Y variable-- i.e. overall result =...

  Abby_Collins14

  Discussions |

  Mar 21, 2024 10:52 PM

  1150 views | 2 replies