BookmarkSubscribeRSS Feed
anders_bankefor

Community Trekker

Joined:

Dec 8, 2015

Relative path, Interactive datafilter and time series analysis

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

Re: Relative path, Interactive datafilter and time series analysis

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

Re: Relative path, Interactive datafilter and time series analysis

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

Re: Relative path, Interactive datafilter and time series analysis

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