cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
ERoderz
Level III

Multiple File Importer opening 2 tables?

I'm attempting to import data from multiple (almost identical) .csv files using the MFI, which I have scripted as   dt = Multiple File Import(  ....

 

I have "Stack Similar Files" checked, selecting data from row 270, with the correct delimiters, but for some reason it is creating 2 separate files, one of which is nonsensical. The other is what I need. I checked and all files have the data I need in row 270.

Anyone have a problem with this?

 

I could get around this if I knew how to rename that second table. The second table is created with a 2 at the end of the file name, Analysis. How do I assign a name to that table that was generated that isn't the original "dt" that I assigned with the Multiple File Import.

ERoderz_1-1700519654497.png

 

I think I'm just rusty on JSL and could use some help. Thanks all!

 

1 ACCEPTED SOLUTION

Accepted Solutions
mmarchandTSI
Level V

Re: Multiple File Importer opening 2 tables?

If you know for sure the name of it, you could just do this:

dt2 = Data Table( "Analysis 2" );
dt2 << Set Name( "Analysis" );

Obviously, if there's any chance of another open table having that name it'll screw everything up....

View solution in original post

2 REPLIES 2
mmarchandTSI
Level V

Re: Multiple File Importer opening 2 tables?

If you know for sure the name of it, you could just do this:

dt2 = Data Table( "Analysis 2" );
dt2 << Set Name( "Analysis" );

Obviously, if there's any chance of another open table having that name it'll screw everything up....

jthi
Super User

Re: Multiple File Importer opening 2 tables?

Multiple File Import returns you a list of table refernces. And you can get the table names using << Get Name if you really need to, but references should be enough

Names Default To Here(1);

mfi_results = Multiple File Import(
	<<Set Folder("$SAMPLE_DATA"),
	<<Set Name Filter("Big Class*.jmp;"),
	<<Set Name Enable(1)
) << Import Data;

Show(mfi_results);

dtnames = mfi_results << get name;

If you need to you can get the references (and names) of all open tables using

dtlist = Get Data Table List();
-Jarmo

Recommended Articles