how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ?

[#1]

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!

[#2 · Accepted solution]

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.

[#3]

Got it,Thanks!