how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ?Is there a way to import multiple excel files with more than one sheets in each excel files ? additionaly, is it possible set subfolder name of each excel files,file names and sheet names as labels ?
Attachments are the raw data and file path for simulation.
thanks!
WindowsRe: how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ?the Multiple File Import() function handles all of your questions except for placing the complete file path(subfolder name). It can only add the file name as a column value.
Re: how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ?Got it,Thanks!
