topic Re: Multiple File Importer opening 2 tables? in Discussions

Multiple File Importer opening 2 tables?

ERoderz — Mon, 20 Nov 2023 22:39:12 GMT

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.

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

Re: Multiple File Importer opening 2 tables?

mmarchandTSI — Mon, 20 Nov 2023 22:51:38 GMT

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....

Re: Multiple File Importer opening 2 tables?

jthi — Tue, 21 Nov 2023 05:22:11 GMT

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();