Hello,
I'm triying to open multiple csv files and hiding them with the property private when using Multiple File Import () << Import Data.
I am currently using a loop with the Open function :
Open(myFile, private)
It works well, the tables are hidden, but I saw the Multiple File Import function which seems to be faster than the previous loop.
However, when using the << Import Data function, all the tables are opened and visible, and I didn't find a way to hide them with the private property :
mfi = Multiple File Import(
<<Set Folder(filesPath),
<<Set Show Hidden( 0 ),
<<Set Subfolders( 0 ),
<<Set Name Filter("*.csv; "),
<<Set Name Enable( 1 ),
<<Set Size Filter( {30907123, 30907123} ),
<<Set Size Enable( 0 ),
<<Set Date Filter( {3736158965.466, 3736158965.466} ),
<<Set Date Enable( 0 ),
<<Set Add File Name Column( 1 ),
<<Set Add File Size Column( 0 ),
<<Set Add File Date Column( 0 ),
<<Set Import Mode( "CSVData" ),
<<Set Charset( "Meilleure supposition" ),
<<Set Stack Mode( "Table Per File" ),
<<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( 0 ),
<<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( "" ),
<<Set Import Callback( Empty() )
);
// Here, I store every table in a list, but every table are visible
dtList = mfi << Import Data;
Is there a way to do that ?
I am using JMP 16.0.0 with French language. Let me know if you need more information.
Thank you !
