cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
patriciafm811
Level II

Multi File Import Change Output Name

I know this has been asked before, but I followed that solution and I cannot make it work. I am trying to import multiple files using MFI (which I can do), but it defaults to its own output table name. How do I change that output name (both scripting and where in the script)? Using JMP 17. 

 

<JSL>

// Import multiple files
Multiple File Import(
	<<Set Folder( "C:\Users\bfkhp\OneDrive - grifols.com\JMP\2023\Monthly Donor Status Files\Excel\" ),
	<<Set Show Hidden( 0 ),
	<<Set Subfolders( 0 ),
	<<Set Name Filter( "*;" ),
	<<Set Name Enable( 0 ),
	<<Set Size Filter( {133163, 167378} ),
	<<Set Size Enable( 0 ),
	<<Set Date Filter( {3779100239, 3779770391} ),
	<<Set Date Enable( 0 ),
	<<Set Add File Name Column( 0 ),
	<<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( "" ),
	<<Set XML Method( "guess" ),
	<<Set XML Guess( "huge" ),
	<<Set XML Settings( XML Settings() ),
	<<Set JSON Method( "guess" ),
	<<Set JSON Guess( "huge" ),
	<<Set JSON Settings( JSON Settings() ),
	<<Set PDF Method( "guess" ),
	<<Set PDF Settings( PDF All Tables( Combine( All ) ) ),
	<<Set Import Callback( Empty() )
) << Import Data;
 
 
3 REPLIES 3
jthi
Super User

Re: Multi File Import Change Output Name

What do you wish to change? The resulting table name? I think you will have to loop over the results (MFI returns a list of files) and use << Set Name

-Jarmo
voy-voy
Level II

Re: Multi File Import Change Output Name

Hello, 

I always have the same problem. Did you find a Solution?

hogi
Level XII

Re: Multi File Import Change Output Name

yes:

@jthi wrote:

loop over the results (MFI returns a list of files) and use << Set Name


maybe: concatenate the tables and then change the name.