Subscribe Bookmark RSS Feed

Relative path, Interactive datafilter and time series analysis

anders_bankefor

Community Trekker

Joined:

Dec 8, 2015

Hi,

I've got a  3 in 1 question:

1. I would like JMP to pick up a "template-table" from the same directory that the script is located. This pathway may vary depending on user due to network setup. I've managed to use the following "fixed" link:

TempTable = "K:\...\TableTemplate.jmp";

open (TempTable);

(this setup works)

the data table is located in the same directory as the script, therefore I would reason that I should be able to use:

TempTable ="..\[path]\TableTemplate.jmp"

open (TempTable);

However this doesnt work.

2. I would like to create an interactive data filter:

dt = open (table);

TableWindow = New Window( "Enter Input",

   

      H List Box (

//Create a text box and input box.

          Text Box ("Enter the Values"),

          Spacers Box (size (1,10));

          Filter = Number Edit Box ( . ),

),

//Create a button box that will use the Filter to select and subset specific data into a new table.

           Button Box ("Add value",

                        

               If ( Is Missing (Filter<<get) == 0 ),              

              

              

               dt << Select Where( :Value == (Filter <<get) ),

               dt << Subset(( Selected Rows ), Output Table Name("subset"));

               TableWindow << Close Window;

          ,

               Filter << set ( . );

               Dialog ("Value incorrect");

);

3. I've got a script that plots numerical values on the Y-axis and batches (characters) on the X-axis. I'm trying to figure out a way to generate a report that will state all samples with values below the avarage of the whole population. Maybe it could work something like this:

dt << Select Where(:Sample == X),

meanX = Mean(Value);

dt << Select Where (:Sample == X & Value < meanX)

//subtset all columns related to these rows

dt << Subset(( Selected Rows ), Output Table Name("subset"));

Thanks for all the help, cheers!

3 REPLIES
anders_bankefor

Community Trekker

Joined:

Dec 8, 2015

2nd question is solved by:

InputWindow = New Window( "Enter Input",


V List Box(

  Spacer Box( size( 1, 10 ) ),

  Text Box( " Enter in the inputs" ),

  Spacer Box( size( 1, 10 ) ),

  H List Box(

   Text Box( "Max respons uppgift 1" ),

   Spacer Box( size( 10, 1 ) ),

   Median = Number Edit Box( . ),

   Spacer Box( size( 10, 1 ) ),

 

  ),

  Spacer Box( size( 1, 10 ) ),

  H List Box(

   Button Box( "Lägg till värde",

  

    If( Is Missing( Median << get ) == 0,

     Table << Select Where( :ISU > (Median << get) );

     Table << Subset(( Selected Rows ), Output Table Name("Ber1"));

     InputWindow << Close Window;

,

     Median << set( . );

   

     Dialog( "ogiltiga värden:" );

    )

   ),

   Spacer Box( size( 10, 1 ) ),

 

   Button Box( "Stäng",

InputWindow << Close Window

)

);

David_Burnham

Super User

Joined:

Jul 13, 2011

if you still have a problem with any of these then it's probably best to post them as individual questions

-Dave
anders_bankefor

Community Trekker

Joined:

Dec 8, 2015

Hi,

thank you for your reply. I've been able to solve two of these problems however the relative path issue still remains an open issue. I will create a new ticket for this issue.

Kind Regards

Anders