Welcome to the JMP User Community!

Latest Discussions

• Excluding data from Graph Based on Value

  Is there a way to graph data, if it occurs 2 or more times? 
  
  For instance: 
  Column 1: Family Name
  Column 2: Rooms of the House with a Television in it
  
  Is there a way for me to sort and graph my data to only include families with 2 or more Televisions? 

  ClusteredTable4

  Discussions |

  Nov 11, 2022 6:07 PM

  1573 views | 3 replies

• Opening a specific date range from SQL tables

  I open a lot of tables from SQL and I would like to be able to open just the previous 7 days. So when I run the script I want it to look at the date/time column on the sql table and open only the data for the previous 7 days.  Here is my open table script:
  Open Database(
  "DSN=0.20;UID=****=****;APP=JMP;WSID=VJDSTATION;DATABASE=BioControl;",
  "SELECT * FROM dbo.VisitLog", "VisitLog"
  ); The column I want...

  JocelynJohnson

  Discussions |

  Nov 11, 2022 1:29 PM

  1597 views | 1 replies

• Regex Issure with Decimals and Whole Numbers

  Hello! Using JMP 16.2: I have a column with whole numbers and decimal numbers. I want to create a new column that flags the whole numbers (or the decimals).  Column Name: ValueColumn Inputs:0.533.76810etc. I have tried several versions of the following Regex using a column formula:Regex(Value,"\d+\,\d+", "Decimal")Regex(Char(Value),"\d+\,\d+", "Decimal")I have also tried parentheses and brackets t...

  Maerawlings

  Discussions |

  Nov 11, 2022 10:11 AM

  2294 views | 3 replies

• How to add the date to file name while uploading a file to s3 bucket using alteryx

  I have a workflow in alteryx where I am downloading two files from two different urls. After making the required modifications I want to upload them to the s3 bucket as well as save a copy locally. I want to add the current date while saving the file in both cases. I was successful in using a formula tool to rename the file saved locally. But unable to do for the copy being uploaded to s3. Can any...

  pavanroast

  Discussions |

  Nov 11, 2022 3:03 AM

  1058 views | 1 replies

• GR&R method used by JMP

  HiI would like to know the details of the GR&R method used by JMP. I have tried to replicate the JMP's results by writing a simple code in Python. I am assuming JMP is using ANOVA method (https://www.spcforexcel.com/knowledge/measurement-systems-analysis/anova-gage-rr-part-1) but, I never get the same results as JMP calculations. Could someone direct me to the related JMP documentation? Thank you

  LoglinearRange8

  Discussions |

  Nov 10, 2022 10:17 AM

  1724 views | 2 replies