cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
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