Welcome to the JMP User Community!

Latest Discussions

• JSON to data table: how to avoid NULL columns being automatically dropped?

  Hi All, I'm using JMP 15 and have JSL that retrieves a JSON payload via Http Request(), runs it through Char to Blob(), and then open()s it in a data table. The JSON payload content is dynamic, but is always mappable to a tabular format (rows and columns). The issue: if any keys in the JSON have all NULL values, they are not included in the data table (i.e., no columns are created for these keys)....

  andykpdf

  Discussions |

  Mar 21, 2021 2:19 PM

  9161 views | 6 replies

• Creating column subset based on list which may contain non-existent columns

  Hi Users, I read through a prior discussion related to this topic but did not find all the answers.I would like to know how to create a column subset based on a given list of columns. I know that you can easily do this when the columns in the given list exist in the datatable you would like to subset.What I want to know is how do you make the script robust so that it does not give the error that "...

  simon_2

  Discussions |

  Mar 20, 2021 6:41 PM

  2431 views | 3 replies

• Report Automation on numerous variables based on certain requirements

  Greetings,I am a newbee to JMP and used it mainly for exploring my data by drag and drop. Now I have QC report that I believe may require JSL codes. The report requirements and design are as follows:Data Source: SQL Tables, SAS, or CSV (data are available in these three formats)Data Sets: There are more than 100+ Tables or data setsData Sets relationships: There are two common fields in each Table...

  helalmob

  Discussions |

  Mar 20, 2021 5:38 PM

  2647 views | 2 replies

• Seperating year by Quarters

  I am trying to seperate the year by quarters using dates. I was looking at documentation and it gave the extract function.EXTRACT( datepart, datetime, )I am not sure how quiet to use it, my idea is if data is between Jan 1st and March 28th its Q1 etcI could use if (Jan1st <:Date< Jan1st + In Weeks( 13 ), "Q1",                      Jan1st + In Weeks( 13 )+ In Days(1) <:Date< (Jan1st + In Weeks( 13 ...

  jearls11

  Discussions |

  Mar 20, 2021 11:06 AM

  2810 views | 3 replies

• Capturing degradation fit parameters to table?

  How do I capture reliability degradation fit parameters to table? The four bolded lines are the crux of what I am trying to do. Fitting the degradation and then simply capturing the fit parameters in a column.   Script below:     Degradation( Y( :current ), Time( :time ), Label( :DUT ), Application( Repeated Measures Degradation ), Connect Data Markers( 1 ), Show Fitted Lin...

  galactus3000

  Discussions |

  Mar 20, 2021 4:23 AM

  10897 views | 11 replies