Welcome to the JMP User Community!

Latest Discussions

• Accessing all columns in a Project with multiple files and same index

  I have a project with three tables (A, B, C) which I am using to create a virtual join.A:index < ReferenceB:index < Linked with A:indexc: index < Linked with A:indexFrom B and C, I can see A columns, but how I can see from A all the columns? In general, what I would like is to access all columns with the Graph Builder.     

  FN

  Discussions |

  Apr 19, 2021 10:31 AM

  1478 views | 2 replies

• Interactive Capability Plot - possible to convert PPM to % easily?

  Hi all. While running the interactive Capability Plot, the Expected PPM changes as I move spec limits, etc.Is there any way to change this Expected PPM to display simple Percentages (in the way that Observed % does) ? The usual 'Format Column' option to convert to % doesn't work, and I'm getting tired of constantly converting Expected PPM to % in my head (or explaining PPM to people - who just wan...

  kom

  Discussions |

  Apr 19, 2021 8:50 AM

  2876 views | 4 replies

• Extracting digits before and after the comma

  Hi, I'm struggling from extracting digits from a string before and after the commahow can I get 0.98 and 0.97 from a string?string = "A_BD_CEEE:0.98,0.975620708"; first_number = Num( Regex( string, "(\d\d?\d?):", "\1" ) );expected outfirst_number = 0.98second_number = 0.975 thanks 

  joshua

  Discussions |

  Apr 17, 2021 4:24 AM

  2990 views | 3 replies

• Column header naming

  Hi,I have a datasheet from my workplace with different parameters. Each parameter has different column properties to it such as A, B, C. The parameter is XYZ. However, the column header itself has the title XYZ (A). There seemed to be a way to concatenate the parameter name to the column property value but I'm not sure how to do it. When i double click on the column header, it just shows XYZ, with...

  SCWong

  Discussions |

  Apr 16, 2021 4:45 AM

  1303 views | 2 replies

• JSL code needed to generate dynamic formula column that sums columns from a list

  Hi All,    This question is in relation to a post here that nicely generates a non-dynamic column for summing up a list of other columns.   The problem I am having is how to sum up the columns (using JSL) when you have a list of N other columns and have it be a dynamic formula.   I have a list of columns in my data table, say ColList, and I want to generate a new column with a formula that simply ...

  SDF1

  Discussions |

  Apr 14, 2021 7:29 AM

  4063 views | 5 replies