topic loading common fields from multiple files in QlikView

loading common fields from multiple files

Tue, 03 May 2016 22:56:22 GMT

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 — Tue, 03 May 2016 23:08:43 GMT

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

sunny_talwar — Wed, 04 May 2016 00:00:36 GMT

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