Multi File Import Change Output Name

patriciafm811 — Tue, 24 Oct 2023 20:14:22 GMT

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;

Re: Multi File Import Change Output Name

jthi — Tue, 24 Oct 2023 19:55:44 GMT

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

Re: Multi File Import Change Output Name

voy-voy — Wed, 21 Aug 2024 12:59:02 GMT

Hello,

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

Re: Multi File Import Change Output Name

hogi — Thu, 22 Aug 2024 16:41:09 GMT

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.

topic Re: Multi File Import Change Output Name in Discussions

Multi File Import Change Output Name

Re: Multi File Import Change Output Name

Re: Multi File Import Change Output Name

Re: Multi File Import Change Output Name