Welcome to the JMP User Community!

Latest Discussions

• Beginner Question about JSL

  I want to save the selected rows in a csv or jmp file using JSL. But I am not able to do it Can anyone tell me how to get it done?I tried by the following code but the way to save it appears to be wrong:f = Function( {a}, theRows = Current Data Table() << get selected rows; Show( theRows ); ); rs = Current Data Table() << make row state handler( f ); filepath = "C:\Users\abc\Desktop\trial"; rs <...

  shasha_2

  Discussions |

  Dec 2, 2021 11:52 PM

  1813 views | 4 replies

• 如何能不用循环的方式求出结果？

  例如按身高的数值大于63的堆数:   这个堆数是指:当相邻行数连续大于63时计数为1、这样计数应该是有 8  这个用循环的方式能得到结果、请教是否还有其它方式可以得到结果。谢谢！  

  lala

  Discussions |

  Dec 2, 2021 7:14 PM

  1742 views | 3 replies

• Create Database Connection Error

  I'm trying to establish connection to database through scripting and it's the first time I'm doing this. I was able to create the following script but it seems that there's a bug that everytime there's unsuccessful connection, there's a default "JMP Alert" pop-up (see snapshot) instead of being contained within the "Try" function (I was trying with an incorrect database name of "TEST" which led to...

  Djtjhin

  Discussions |

  Dec 2, 2021 4:59 PM

  2683 views | 5 replies

• Anyone have a good JSL .ini file reader?

  I'm imagining   [Thing1] x = 14 y = String z = ... [Thing2] x=DifferentString y=28 becoming [ "Thing1"=> ["x"=>14, //not sure if this should be a number or string "y"=>"String", "z"=>"..."], "Thing2"=> ["x"=>"DifferentString", "y"=>28] ]

  vince_faller

  Discussions |

  Dec 2, 2021 1:01 PM

  2274 views | 6 replies

• Check if table exist on sql db

  Hello,   I am running some jmpquery on different SQL DB. Because some DB do not have the same tables,  I getting the error: Tables (public.table1(t1)) referenced in the SQL Query were not found in the database{1} in access or evaluation of 'Table' , Table( "table1", Schema( "public" ), Alias( "t1" ) ) /*###*/   How could I check if a table exists on a SQL DB before running a query ?    Thanks Geof

  geoff1

  Discussions |

  Dec 2, 2021 11:27 AM

  2452 views | 4 replies