Choose Language Hide Translation Bar
Community Member

JMP script modification

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.

0 Kudos
Community Trekker

Re: JMP script modification

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
0 Kudos