Welcome to the JMP User Community!

Latest Discussions

• import Multiple excel files with many tabs into one table in JMP

  Hi, I am using "import Multiple files" feature to get data from different excel files, my challenge is that only data from the first tab are extracted. I have three more tabs on each file that I would like to get the data from. Is there a way to do that in JMP? appreciate all the help.AFaiz

  AFaiz

  Discussions |

  Jun 13, 2024 4:27 AM

  6291 views | 15 replies

• Quantiles result from JMP are different from Python

  Hi JMP community, I'm trying to build a JMP script to calculate the quantiles 97.5. The issue here is my reference data is using Python in which return a different number. Below is an example: Python P97.5: 2561.35 (equal to PERCENTILE.INC in Excel)JMP P97.5: 2581.375 (equal to PERCENTILE.EXC in Excel) My JSL code: Summarize( dt1, group_by = By( :group ), group_p975 = Quantile( :data, 0.975 ) ); I...

  nthai

  Discussions |

  Jun 13, 2024 3:29 AM

  1332 views | 2 replies

• How to show modal window which running script after it is open?

  I spend some time created a jsl script, which provide user interface to specify some criteria and pull data from Amazon Redshift based on user input. The script is working well but having a small issue. Once user clicks on query button on a modal window, it set a variable isValid = 1, close itself to execute subsequent script, which will then create a progress window that display message like "pul...

  Toy

  Discussions |

  Jun 13, 2024 3:08 AM

  2731 views | 8 replies

• Distribution graph with process capability not working in script

  Hi,
  I want to use this generated script on numerous columns:Distribution( Stack( 1 ), Continuous Distribution( Column( :"VDD_ILIMIT"n ), Horizontal Layout( 1 ), Vertical( 0 ), Outlier Box Plot( 0 ), Process Capability( LSL( . ), Target( . ), USL( 0.5 ), Show as Graph Reference Lines ) ), SendToReport( Dispatch( {"VDD_ILIMIT"}, "1", ScaleBox, {Add Ref Line( 0.5, "Solid", "Blue", "USL",...

  ContentMeerkat5

  Discussions |

  Jun 13, 2024 3:06 AM

  1000 views | 2 replies

• Count value in multiple characters and mark position?

  Hi, how can I count the number 0,1,2 from the 1 characteristic column as below? Thank you so much! (x = missing)PatternCount 0Count 1Count 2Position 0Position 1Position 2x,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 26 1 02,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28402,2,2,2,2,0,0,0,0,0,0,1,1,1,2,0,1,1,1,2,2,2,0,0,0,0,0,0      0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0...

  doraemengs

  Discussions |

  Jun 13, 2024 2:41 AM

  3821 views | 13 replies