Subscribe Bookmark RSS Feed

JMP script modification


Community Member


Jun 23, 2011

I would like to modify an existing script that opens a database on our network. The entire contents of the database is loaded into a data table. The information in the database has multiple years worth of data and columns. Is there a way to exclude specific columns from being pulled? Is there a way to set a date range from which to pull data from the database?

My programming skills are rather limited, so any help you can give will be appreciated.


Community Trekker


Jun 23, 2011

This is more of a SQL question than a JMP question. JMP does have limited SQL writing capability in the "Open Database" in the file menu. However, I would recommend just finding the appropriate SQL code to get the exact output you want. There's plenty of SQL help online; in fact I like to say "Google taught me SQL" :).

Once you get your SQL code, you just put it in the Open Database command in JSL.

Open Database("", "SQL String (e.g. Select * from blah)");

Message was edited by: The Chadd