there is a csv-specific way to omit columns. select columns() probably needs some documentation to say it is specific to JMP data tables. (edit: note sent to development team)
edit: the JSL from the source script after using the csv import wizard
Open(
"$DOWNLOADS/Big_Class.csv",
columns(
New Column( "name", Character, "Nominal" ),
Omitted Column( . ), // leave out the "age" column
New Column( "sex", Character, "Nominal" ),
Omitted Column( . ), // leave out the "height" column
New Column( "weight", Numeric, "Continuous", Format( "Best", 12 ) )
),
Import Settings(
End Of Line( CRLF, CR, LF ),
End Of Field( Comma, CSV( 0 ) ),
Strip Quotes( 1 ),
Use Apostrophe as Quotation Mark( 0 ),
Use Regional Settings( 0 ),
Scan Whole File( 1 ),
Treat empty columns as numeric( 0 ),
CompressNumericColumns( 0 ),
CompressCharacterColumns( 0 ),
CompressAllowListCheck( 0 ),
Labels( 1 ),
Column Names Start( 1 ),
First Named Column( 1 ),
Data Starts( 2 ),
Lines To Read( "All" ),
Year Rule( "20xx" )
)
)
edit: Omitted can replace New like this
Omitted Column( "age", Numeric, "Continuous", Format( "Best", 12 ) ),
to document what is omitted. I'm pretty sure the values are ignored. Makes editing the JSL easier too if there are a lot of columns to ignore.
Craige