Re: How to generate a Matrix from an Excel file by JSL

[Fred Zhang <ieaggie2009@gmail.com>]

Thanks a lot, Mark.

 

All these operations can be done by JMP Script language?

Any example to demonstrate this function?

 

Appreciate your help and consideration,

Feng

On Sun, Feb 8, 2009 at 6:14 AM, Mark Bailey <mark4flies@aol.com> wrote:

I would use the Open Database() function and a SQL query to obtain the subset of the worksheet in a new JMP data table. Then use the Get As Matrix message with the current data table to obtain the matrix of all of the numeric columns.

On Feb 7, 2009, at 7:31 PM, Fred Zhang wrote:

I have a big Excel spreadsheet, and would like to take its subset

as a matrix.

How can I do it by JMP Script?

 

Thanks a lot.

 

Fred

Mark

They hate you if you're clever, and they despise a fool ("Working Class Hero" - John Lennon)

=