Welcome to the JMP User Community!

Latest Discussions

• Problem calling a script with Include()

  Hi All, I have 3 scripts that run different SQL queries to extract data. Another script uses Include() to run each one of those scripts and then makes some modifications to the three tables and joins them.In two of those scripts, when I run the individual script, or the call using Include(), I got the same table. However, for the last script, if I run it I get like 8000 rows, but running it throug...

  Festrus

  Discussions |

  Mar 22, 2024 7:41 AM

  1057 views | 3 replies

• Understand Odd numbers in custom designed RSM+setting continuuos factors to zero

  Dear JMP-Experts,I have two questions:Question 1) I created two RSM-Designs using the custom Designer
  -The first design has 3 Factors, of which two factors (Factor1 and 2) are continuous with three factor settings  and the third factor is discrete numerical with four factor settings (two include 0 as additional setting)-->See below.
  -The second design, is similar to plan 1 but with four factors; thr...

  DualARIMACougar

  Discussions |

  Mar 22, 2024 7:01 AM

  531 views | 1 replies

• 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

  1009 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

  1843 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

  701 views | 1 replies