Welcome to the JMP User Community!

Latest Discussions

• How to use prediction profiler to achieve a combination of target conditions?

  I have a 5 column data. Variation of input parameters/conditions in rows of the first three column results in (measured) values in column 4 and 5. How to use prediction profiler to predict a combination of input parameters/conditions to achieve a target combination (in my case a target concentration and depth)?I would prefer a graphical way but I can also handle JSL.  

  Neo

  Discussions |

  Dec 18, 2023 9:31 AM

  1738 views | 5 replies

• Definitive Screening Design question

  Should you only run a Definitive Screening Design if you know or think you're very close to the process optimum? What happens if you run a DSD, but you're outside the optimum factor space? Would you have wasted your time, and have been better off doing a fractional-factorial 1st to screen items, then doing the full factorial to get curvature afterward? 

  mjz5448

  Discussions |

  Dec 18, 2023 4:01 AM

  2489 views | 8 replies

• Can Substitute implement the function of regular substitution?

  For example, replace the column name [20231216] to show that this 20231216 is a variable 8-digit number:  Col1[20231216]、Col2[20231219]For( i = 2, i <= N Col( dt ), i++, ca = Column( i ) << Get Name; cc = Substitute( ca, "[(.{8,})]", "" );//？？ Column( dt, i ) << set name( cc ); );Thanks!

  lala

  Discussions |

  Dec 17, 2023 5:09 AM

  1167 views | 3 replies

• How to import tab-separated text directly into tabular data with the "Import Multiple Files" function?

  I have set this up, but the imported data still cannot be directly tabular.Thanks!Multiple File Import( <<Set Folder( "C:\7\" ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Set Name Filter( "*.*;" ), <<Set Name Enable( 0 ), <<Set Size Filter( {1491, 2610} ), <<Set Size Enable( 0 ), <<Set Date Filter( {3785240875.633, 3785241343.586} ), <<Set Date Enable( 0 ), <<Set Add File Name Col...

  lala

  Discussions |

  Dec 17, 2023 4:53 AM

  1359 views | 4 replies

• JSL to create formula column with variable column names

  Hi,I need to create a new formula column via script using variables for column names and constant.Tried various combinations of Expr, Eval, Parse, Eval Insert for no avail.See sample.Thanksrow = 11; col = "foo"; for (i = 1, i <= ncols(dt), i++, dt << New Column( "ratio " || char(i), numeric, formula(( column(col) - column(col)[row] ) / (Col Max(col) - Col Min(col)))); );

  RonB

  Discussions |

  Dec 17, 2023 12:18 AM

  1270 views | 2 replies