loading common fields from multiple files

[#1]

Hi ... How would I load say 3 common fields from multiple excel files which have different sheet names

I know usually the statement would be FROM ---- \*xlsx

but what happens about the sheet name ?

[swuehl]

Do you know the file names and sheet names?

Then maybe like

For Each vIter in 'file1.xlsx|Sheet1$' ,'file2.xlsx|Sheet2$'

Let vFile = Subfield('$(vIter)','|',1);

Let vSheet = Subfield('$(vIter)','|',2);

LOAD Field1,

          Field2

[$(vFile)]

(biff, embedded labels, table is $(vSheet));

Next

[sunny_talwar]

There are many example of this on the community where they talk about loading from multiple files, multiple sheets

Load Multiple excel sheets using For loop

Loading Multiple Excel Sheets Dynamically along with file name and sheet name