Welcome to the JMP User Community!

Latest Discussions

• Transposing from WIDE to LONG and a formula question

  Hi--two somewhat related questionsI have used SPLIT to transform a long file to a wide file, but I have a slightly more complicated situation where I want to STACK/transpose a wide file to a long file. I have a dataset with a unique subject ID, and then several hundred columns/variables. The variable names are the exact same with the exception that Year 1 ends '2', Year 2 ends in '3', etc. Is ther...

  plfazeli

  Discussions |

  Mar 19, 2021 8:16 AM

  2169 views | 3 replies

• CMD window for logging never shows up while using RunProgram

  I got an issue while using "RunProgram" to call my exe, a CMD window for logging is supposed to appear, but it never shows up.  The CMD window can normally pop up when I manually run it. Is there anyone who can help me solve the issue? Thanks in advance : )    JSL code: RP = Run Program( Executable( exefilepathRoot || "CommonalityEngine\PyScript\get_data_from_cache.exe" ), Opti...

  baiyun

  Discussions |

  Mar 19, 2021 6:54 AM

  2201 views | 4 replies

• Fill in Missing Data Based on previous column [cell] value

  I apologize for this redundant question about column fill but for the life of me i can't find any of the previous topics. I have a data table that is filled out in an incomplete manner. I need to fill the missing cells below each value with its predecessor. I know it is a Column Formula script that uses the Lag() and Row() but can't find the correct syntax.   

  Yngeinstn

  Discussions |

  Mar 19, 2021 6:50 AM

  2165 views | 1 replies

• Making a Mixture Design that Does Not Sum to 1.0

  I am trying to make an I-optimal mixture design with 3 components that add to 0.883, with the remainder 0.117 being a fourth, but constant, ingredient. I know a possible work around is to normalize my constraints, but to avoid confusion in reporting the information I would like to have the three components add to 0.883. I have tried to add linear constraints (shown in the attached screen shot) but...

  David_J

  Discussions |

  Mar 19, 2021 6:49 AM

  1775 views | 2 replies

• Where Clause in graph loop

  I have some code that is designed to build a report based on some filtering.  It will be fed two lists, the first will determine which materials get pulled (in this example that will be Gender_List), the second determining which properties get graphed (In this example that will be Property_List).   The idea being that there will be a loop through each Gender that will create a matrix of graphs for...

  Evan_Morris

  Discussions |

  Mar 19, 2021 5:16 AM

  3973 views | 8 replies