cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

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