Welcome to the JMP User Community!

Latest Discussions

• how to apply variable to custom SQL

  in custom SQL, this works. .....left join  c
  on d.SCU = c.CU
  where d.DE in (' 216532','216534')in script, I define a variable: inString = ' 216532','216534'then I like to run custom SQL:.....left join  c
  on d.SCU = c.CU
  where d.DE in (' inString')but i doesn't work. how do I use my variable in custom SQL correctly?

  ReliabilityWolf

  Discussions |

  Jun 16, 2024 9:52 PM

  832 views | 1 replies

• "Graph Builder" adds On Colse() function, exception when encryption runs

  JMP community expert, I'm from China.
  The following problem description comes from machine translation. Please don't mind that the grammar can be a little strange. I am encountering some issues with a potential bug in the JMP17 script. I would appreciate it if you could seek assistance from the experts to address this matter. I have created a script for "Graph Builder". In order to automatically cl...

  fengzhuansha

  Discussions |

  Jun 16, 2024 6:14 PM

  1445 views | 4 replies

• ThisDataTable() ?

  For Columns and Objects like Reports, there exists  a commandobj << Get Data Table();to get a reference to the respective data table. Is there a similar function for Table Scripts? something like This Data Table() some lazy implementations which could lead to issues:reference the data table by its name.
  Data Table ("my table") << new column("test")
  this works till there is a conflict with another da...

  hogi

  Discussions |

  Jun 16, 2024 8:46 AM

  2243 views | 5 replies

• run table script

  What is the difference between running a Table Script via the green Play icon: ... and via the Run button? 

  hogi

  Discussions |

  Jun 16, 2024 8:24 AM

  4455 views | 12 replies

• Graph Builder: Unclear statistics when using multiple response columns

  Hi all,
  
  I have a problem reagrding statistics/bar graphs using multiple response columns. As an example, I will use the Big Class Families data table, and I'm using JMP18.
  I want to plot the fraction of persons, which have visited specific countries, for simplicity I restricted the age to 14. I made a graph builder with the following script:
  
  Graph Builder( Size( 1097, 475 ), Legend Position( "Right" ...

  gnu23

  Discussions |

  Jun 15, 2024 2:44 AM

  3935 views | 10 replies