Welcome to the JMP User Community!

Latest Discussions

• Share JSL scripts but avoid unintentional tinkering of the scripts

  I have prepared a bunch of JSL scripts (on JMP 13) which are designed to pull test data from the database and generate a journal report.There is a main script and there are other other scripts and functions which the main script and other scripts call.I would like to share my scripts to other JMP users in my group so that they can run the main script to generate the necessary journal reports. Howe...

  Neo

  Discussions |

  Dec 3, 2021 7:32 AM

  1430 views | 4 replies

• 如何能不用循环的方式求出结果？

  例如按身高的数值大于63的堆数:   这个堆数是指:当相邻行数连续大于63时计数为1、这样计数应该是有 8  这个用循环的方式能得到结果、请教是否还有其它方式可以得到结果。谢谢！  

  lala

  Discussions |

  Dec 2, 2021 7:14 PM

  1742 views | 3 replies

• 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

  2452 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

  3116 views | 5 replies

• go through each zip folder to get list of files name from it and save in a single table

  Hi, I need some help here. I tried to write the jsl but I got stuck and hope someone can guide me here. I have a directory that contain 10000+ zipped folders. Each zipped folder has 100+ files. I want to do task below without unzip WITHOUT UNZIP the zipped folders.
  1) get the name of each zipped folder. 2) get into individual zipped folder. 3) get the files in the zipped folder. 4) in a table, add ...

  dadawasozo

  Discussions |

  Dec 1, 2021 11:46 AM

  3437 views | 4 replies