Loading Value from Single Cell in Excel to QlikView

HareeshR — Wed, 21 Aug 2019 19:11:48 GMT

I want to load data from multiple files, but just the data in G14 cell in all the files, along with file name.

Load G,

FileBaseName()

From test.xslx

(ooxml, no label, table is Sheet) WHERE RecNo()=14

This is not working. Any suggestions???

Re: Loading Value from Single Cell in Excel to QlikView

marcus_sommer — Thu, 22 Aug 2019 08:27:49 GMT

Try it with:

first 1 Load G as Field, FileBaseName() as File From test.xslx
(ooxml, no label, header is 14 lines, table is Sheet);

- Marcus