Welcome to the JMP User Community!

Latest Discussions

• How to find the Max difference between two tests by counting number of cells between events.

  I have attached a mini file.If the cell of a lot passes TEST 1 and TEST 2 its status is PASS.If a cell fails TEST 1 and TEST 2 its status is SAME.If a cell fails a test but passes the other test its status is DIFF.For each lot I am trying to determine the Max distance by cell count from a DIFF to its nearest SAME.What would be the best way to go about this?ThanksFiona

  fionaweston

  Discussions |

  Jan 4, 2023 9:40 AM

  1919 views | 3 replies

• How to correct sequence/order in a column with standard reference and if it does not follow over write it with some rules.

    Dear All,
  
  I recently asked a question how to fill missing values in a column and got/implemented the solution. But I am stuck again. This problem is the continuation of the same (2nd stage issue.)
  
  Reference of previous problem -
  https://community.jmp.com/t5/Discussions/How-to-fill-replace-text-between-two-cells-based-on-specific/m-p/581800#M78854
  I want to generate a column "Device_State_Final_Corre...

  HSS

  Discussions |

  Jan 4, 2023 9:15 AM

  2081 views | 3 replies

• Pause Script Until After User Manually Works on Data Table

  Folks, I'm trying to pause my script so that a user can manually work on an open data table (manually examine data and add/delete rows or columns) before proceeding.  I've tried using a dialog box to accomplish this, but I can't work on the data table until after the dialog box is accepted.  Does anyone have any suggestions on how I can accomplish this?   Clear Log();Names Default to Here ( 1 );dt...

  terapin

  Discussions |

  Jan 4, 2023 9:08 AM

  7502 views | 6 replies

• how to sort and compare columns when data is not identical

  I have data from two separate runs.data include: X,Y,ZI want to comapre results based on X,Y coordinates (Z is the results)the problem: for each run i get different coordinates. well, not completely different but not identical. within a range of +- 10.how can i sort the data and compare the results (it has to be X and Y, not one of them only).see table for example, (I've arranged the data in that ...

  Ohad_s

  Discussions |

  Jan 4, 2023 7:21 AM

  1804 views | 3 replies

• Can I pause a script to allow a user to edit a data table

  I currently have a script which if run as highlighted lines works perfectly.  Highlighting the first lines, a data table is created (from an SQL Query) and the script stops.That table can then be edited (some rows are highlighted or deleted) and then the 2nd half of the script can be run. I'd like for a user to run this without having to highlight script lines, so I need a way to pause the script ...

  pcarroll1

  Discussions |

  Jan 4, 2023 6:43 AM

  3155 views | 2 replies