I am importing ~140000 rows of data from 20 preexisting jmp files using this script in windows 11, JMP 18.1.0
Multiple File Import(
<<Set Folder( "C:\here\there\"),
<<Set Name Filter( "*.jmp;" ), <<Set Name Enable( 1 ),
<<Set Size Filter( {1, 1} ), <<Set Size Enable( 0 ),
<<Set Date Filter( {Today() - indays(10), Today()} ), <<Set Date Enable( 1 ),
<<Set Add File Name Column( 1 ), <<Set Add File Size Column( 0 ), <<Set Add File Date Column( 0 ),
<<Set Import Mode( "CSVData" ), <<Set Charset( "Best Guess" ), <<Set Stack Mode( "Stack Similar" ),
<<Set CSV Has Headers( 1 ), <<Set CSV Allow Numeric( 1 ), <<Set CSV First Header Line( 1 ),
<<Set CSV Number Of Header Lines( 1 ), <<Set CSV First Data Line( 2 ), <<Set CSV EOF Comma( 1 ),
<<Set CSV EOF Tab( 0 ), <<Set CSV EOF Space( 0 ), <<Set CSV EOF Spaces( 0 ),
<<Set CSV EOF Other( "" ), <<Set CSV EOL CRLF( 1 ), <<Set CSV EOL CR( 1 ), <<Set CSV EOL LF( 1 ),
<<Set CSV EOL Semicolon( 0 ), <<Set CSV EOL Other( "" ), <<Set CSV Quote( "\!"" ), <<Set CSV Escape( "" )
) << Import Data;
I do see now it may be strange to specify JMP files and then list CSV import settings. I think this script was created by JMP 14 automatically. The import works just fine, and the data table looks very normal (initially). (All my other data tables work fine.)
This table has a bug in it - every time I use the above script to generate it: If I select the first row and invert the row selection, I should have 139,999 rows selected - but i only have 70,921. Over 60k remain unselected. If I select one of those unselected rows, and invert the row selection again, then again, 70,900 rows are selected, but I can not unselect any of them by clicking. I can invert the selection state of multiple rows if if I click-drag over multiple rows. If I select any row, and delete it, I instantly have -37k rows selected. If I delete all the rows, I still have -37k rows selected. This is not convenient. Is there a solution?