Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Relative path, Interactive datafilter and time series analysis

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Relative path, Interactive datafilter and time series analysis

Dec 21, 2015 5:06 PM
(2601 views)

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 3

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

)

);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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