Welcome to the JMP User Community!

Latest Discussions

• Multi File Import Change Output Name

  I know this has been asked before, but I followed that solution and I cannot make it work. I am trying to import multiple files using MFI (which I can do), but it defaults to its own output table name. How do I change that output name (both scripting and where in the script)? Using JMP 17.    <JSL> // Import multiple files Multiple File Import( <<Set Folder( "C:\Users\bfkhp\OneDrive - grifols.com...

  patriciafm811

  Discussions |

  Aug 22, 2024 9:41 AM

  1283 views | 3 replies

• Machine data source list remove in "Database Operations"

  I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean

  Sean_ShCn0

  Discussions |

  Aug 22, 2024 7:24 AM

  749 views | 0 replies

• Write Data from Data Table to Database

  Hello JMP-Community,I am searching your help here because I didn't found a sufficent solution for myself in other posts. It is about writing content of a data table into a table of a database.For that I wrote this little function: myInsertInto = function({dt, dbConnection, destinationName}, cols = dt << GetColumnNames(String); rows = dt << Select All Rows << GetSelectedRows; show(cols, rows); ...

  DBo_94

  Discussions |

  Aug 22, 2024 6:38 AM

  555 views | 0 replies

• How F Ratio Value is determined for Brown-Forsythe and Levene's test for Equal Variance

  I had evaluate the JMP output for Brown-Forsythe and Levene's test for Equal Variance under Fit X-Y analysis module.  The values from the JMP Fit X-Y are F-Ratio, DOF for factor, DOF for sample, and Prop>F.  I performed Levenes and Brown-Forsythe test in excel using the single factor ANOVA module in the data analysis add-on to complete the Levenes and Brown-Forsythe analysis.  The F-ratio from JMP...

  Brice_L

  Discussions |

  Aug 22, 2024 2:10 AM

  4874 views | 7 replies

• How to select row with specific criteria from left or right of digit string?

  From example in sample.xlsx. I have a list of IDs. In my case, I have tens of thousands of those. I need to remove rows where number starts from "204". I tried using:Data Table ("Sample") << Select Where ( Contains(:Sample ID, "240")) << Delete Rows; But this will also select and delete even when "240" is in the middle of digit string. What do I do if I want to only remove when my Sample ID starts...

  Azim

  Discussions |

  Aug 21, 2024 4:28 AM

  719 views | 1 replies