Welcome to the JMP User Community!

Latest Discussions

• Auto Annotate Plots

  I have created a script to take a spec document and apply spec limits and notes to a data file.  I was trying to come up with a way to automatically add the notes input as an annotation to the subsequent plots. I came up with this with a lot of help from the user community.  Wondering if there are obvious opportunities to make the script more flexible in terms of plot types that can auto annotate?...

  SpannerHead

  Discussions |

  Feb 6, 2024 10:50 AM

  697 views | 1 replies

• JSL Query Table: Strange result

  
dirLoc=Pick Directory("Select a directory", "my directory"); fileList = Files In Directory(dirLoc); dt1 = open(dirLoc || fileList[1]); dt1 << Select Where( :Amount>=1000 ); x=dt1<<Subset(Output Table Name("T1")); Close(dt1, NoSave); show(N Row(x)); x << Save("my directory\t1.jmp");Greetings!I am trying a simple query with a sample data file. The query returns right set of resu...

  monir

  Discussions |

  Feb 6, 2024 8:54 AM

  764 views | 2 replies

• JMP import csv, shows as empty

  Hi team,  The table shows as empty when i choose to import through csv file. I saw couple posts before showing there is a issue with uploading with csv, just wondered if there is a workaround for this issue? Or do I have to upload through xlsx file?   ThanksJason

  OutputCivet4254

  Discussions |

  Feb 5, 2024 2:14 PM

  624 views | 1 replies

• Getting work week (WW) from "m/d/y h:m:s AM|PM" format

  Hi,
  
  I have a trouble to getting the work week from rows. Let's say I have a date and time format like this I tried following things by following the JSL manual @ page 150 and so forth but could not resolve this,
  first I thought that I need to get rid of time values dt << New Column( "Date_new", Numeric, Continuous, Formula(Format(:Name("Date"), "m/d/y")), );Then now I have the dates like this 
  
  Next I...

  joshua

  Discussions |

  Feb 5, 2024 12:31 PM

  4612 views | 6 replies

• Exporting full LCA dataset to CSV/Excel

  I conducted an LCA analysis on survey questions. In the "parameter estimates" section of the generated report, there is a table. When I export it, it doesn't export the merged cells on top. For example:
  
  Cluster 1:  [Top Column: State]                   [AZ] [VA], [DC], [TX] It only exports the cluster, and the parameter estimates for [AZ] [VA], [DC], [TX]. I want to export every visible thing, incl...

  WeightedColt463

  Discussions |

  Feb 5, 2024 12:18 PM

  1004 views | 2 replies