Hi,
I 'm using the query builder to get data from database. The the included columns from table are a mixed of categorical and numerical type. After I clicked Run Query, a table appears and contains all the columns I needed. However , all the columns appear in categorical type. How I can make sure not losing the data type when query data using jmp?
Here
Right click the icons to get the popup.Right click the icons to get the popup.
I'm not an expert on query builder, but the simple example worked for me in JMP 16.
It might make a difference if the database columns are character rather than numeric.
What version of JMP?
Add a picture might help too.
14.3 works as I expect, the continuous default is not changed. I'm out of suggestions, except to look at the source script in the opened table; you might be able to change to "Continuous" (or delete) the highlighted bits and get what you need.
New SQL Query(
Connection(
"ODBC:DSN=CSV;DBQ=C:\SPACE\SAS\JMP\15\SAMPLES\IMPORT DATA;DefaultDir=C:\SPACE\SAS\JMP\15\SAMPLES\IMPORT DATA;DriverId=27;FIL=text;MaxBufferSize=2048;PageTimeout=5;"
),
QueryName( "Big Class.csv" ),
Select(
Column( "name", "t1" ),
Column( "age", "t1" ),
Column( "sex", "t1" ),
Column( "height", "t1", Analysis Type( "Ordinal" ) ),
Column( "weight", "t1", Analysis Type( "Nominal" ) )
),
From( Table( "Big Class.csv", Alias( "t1" ) ) )
) << Run
Beyond that, I'd suggest tech support. (Might be good anyway; it does sound like a bug.)
