Welcome to the JMP User Community!

Latest Discussions

• Function to copy down data based on a selection criteria

  Hi, Would it be possible to create a function, script or column formula to copy over information from a column based on a selection that is made in other columns. Some sort of VLOOKUP function if I would need to describe this. I have attached a JMP table as an example. I would like to populate the Adjusted Time column with data from the Time column. And this should be done in a manner that if Stag...

  RobRobeyns

  Discussions |

  Dec 18, 2020 7:55 AM

  2080 views | 3 replies

• JSL > Graph Builder > Graphic script > Text background color and transparency?

  Hi JMP Community, I'm trying to assign a background color and transparency to dynamically added text via a graphic script (see below) but I have not been able to find the right approach to do so. Also, I would like to have the text and its background as the top layer in GB plot to dim out any plot elements overlapping with the text.As you may have seen in a previous post, I thought that drawing a ...

  Thierry_S

  Discussions |

  Dec 18, 2020 4:01 AM

  2093 views | 2 replies

• Data evaluation

  Hello everybody, I do have a data set with the following columns: - Production Date/time
  - Shift (3 per day)
  - Location of interim storage (10 locations with 75 different options for each location)
  - Batchnumber
  - Product thickness (ranging from 100 to 1000)
  - Product length (1 or 2)
  - Quality inspection at the end of process for each product (Good or Bad) The data of a row represents the data for one p...

  JohannesENS

  Discussions |

  Dec 18, 2020 12:36 AM

  2777 views | 6 replies

• Force Import Format of Excel columns

  Dear community, I am trying to import data from the attached Excel file "DATA_SAMPLE_TO_IMPORT.xlsx", using following jsl script: Open( ".\DATA_SAMPLE_TO_IMPORT.xlsx", Worksheets( "DATA" ), 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 ), ...

  J_Bonnouvrier1

  Discussions |

  Dec 18, 2020 12:36 AM

  4463 views | 5 replies

• Getting a list of tables from Access Database

  Hello,I'm trying to create a userform in the application builder, using native functionnalities and why not, JSL. I have the ideas and now I need to go on... Firstable, does anyone know how I can get a list of all the tables in my Access Database? Of course that list would be on the userform.Thank you for your support, I'm starting manipulate JMP 11.

  cyrille_wagner

  Discussions |

  Dec 17, 2020 9:47 PM

  21294 views | 5 replies