cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
gregpearce
Level I

Multiple File Import Auto-Naming Data Table

Hello All,

 

I'm writing a script where I start with a 'multiple file import' of a folder of .csv files. I will periodically be getting new .csv files that I would like to add. These files have a series of letters and numbers (i.e chghistory0857-786.csv, chghistory0956-783.csv, chghistory1008-805.csv, etc). The issue I'm running into is when I run the 'multiple file import' script, JMP creates a data table name that is auto named based on the .csv file names (i.e. chghistory0956-783_chghistory1008-805). When I put more data files into the folder, this name changes and messes up all future formulas.

 

Is there a way to pre-establish the data table name and have the data from the MFI dumped into it? JMP16 user here if that makes a difference.

 

Thank you,

Greg 

11 REPLIES 11

Re: Multiple File Import Auto-Naming Data Table

I have the same problem!

txnelson
Super User

Re: Multiple File Import Auto-Naming Data Table

Doesn't the provided solution provide the answer you need?

Jim