Subscribe Bookmark RSS Feed

JMP script modification

sunshine75

Community Member

Joined:

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.

Thanks!
1 REPLY
thechadd

Community Trekker

Joined:

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