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

[Fred Zhang <ieaggie2009@gmail.com>]

Thanks, Mark.

 

But in my data table, there are some attribute and character columns,

so I need to extract the subset (some columns and rows) of the table to produce

a pure numeric matrx.

In your scheme, I need to do the above in "SOL string" by selecting the columns?

 

Also, what is "DNS string"?

 

Best regards,

Fred

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

Schematically:

dt = Open Database(

"DNS string",

"SQL string"

);

m = dt << Get As Matrix;

That's about it. Well, at least as far as you have described the problem!

Best of luck.

Mark

On Feb 8, 2009, at 10:27 AM, Fred Zhang wrote:

All these operations can be done by JMP Script language?

Any example to demonstrate this function?

Mark

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

=