Welcome to the JMP User Community!

Latest Discussions

• Check if table exist on sql db

  Hello,   I am running some jmpquery on different SQL DB. Because some DB do not have the same tables,  I getting the error: Tables (public.table1(t1)) referenced in the SQL Query were not found in the database{1} in access or evaluation of 'Table' , Table( "table1", Schema( "public" ), Alias( "t1" ) ) /*###*/   How could I check if a table exists on a SQL DB before running a query ?    Thanks Geof

  geoff1

  Discussions |

  Dec 2, 2021 11:27 AM

  2496 views | 4 replies

• [4PL fitting] Different inflection points using different units of concentration

  Hello the community,   We are facing some issue in our inflection point calculation for a nonlinear 4P Rodbard fitting.    The model is basic: X: concentration [nM] Y: %Specific Killing  By: samples   I usually run this on JMP, but other team members in our departement are using the service of ou bio-informatitian and she used the concentration in pM.  At first sight, no issue, only a factor of 10...

  JBE

  Discussions |

  Dec 2, 2021 7:02 AM

  3163 views | 5 replies

• Issues with recognizing an argument in the script

  Hi, Can someone please have a look at my script and give me an idea what I'm doing wrong. Trying to select and argument using comb box which ten is incorporated into the column name and based on that column im trying to generate control chart using the adjusted column name but it doesn't work.   Names Default To Here( 1 ); New Window( "Data selection", <<Modal, Panel Box( "Select a Date Ra...

  swiergi11

  Discussions |

  Dec 2, 2021 6:26 AM

  2242 views | 5 replies

• JSL Partition get selected rows

  I am using the JMP Partition() function in my JSL script for the decision tree, I wanted to know how to get the selected rows once the user selects the segment for which rows are selected. I tried using the Get Selected Row but it's not able to understand the table. Does anyone has any idea how to code it?

  shasha_2

  Discussions |

  Dec 2, 2021 3:19 AM

  1876 views | 3 replies

• Bin a defect using a priority list

  I have attached table1 which consist of 3 input columns (Part No, Yield and Defects) and 1 output column (Bin). I have also attached another priority_table stating the hierarchy of the defects with cracks as the most important.   How do I generate the output column Bin, using JMP scripting where if a Part No has a few defects, put the most important defect in the Bin column for all the rows concer...

  cchueng

  Discussions |

  Dec 1, 2021 9:56 PM

  3451 views | 6 replies