topic Re: Expression in QlikView

Expression

Wed, 10 Dec 2014 12:29:43 GMT

Hi All,

let me explain : I have 12 excel sheets by month name 02-01-2014 to 02-12-2014 .

I want to know what expression do i need to write in the edit script so that i can fetch all the 12 excel sheets . I dont want to load individual ecel sheet from table view. I hope iam clear

Thanks in Advance.

kane

Re: Expression

Michiel_QV_Fan — Wed, 10 Dec 2014 12:35:01 GMT

If they are in 1 Excel work book, thus12 tabs, just remove the sheet from the load statement

(biff, no labels, table is Ritten$); will be (biff, no labels);

If you have 12 different work books replace the name of the work books in the load with a * (wildcard). Then all 12 are loaded.

FROM

(biff, no labels, table is Ritten$);

Re: Expression

Wed, 10 Dec 2014 12:39:30 GMT

Hi,

You can use a loop to process all sheets in the file. Like this:

for index = 1 to 12

let TableName='02-'&Num(index,'00')&'-2014';

MyTable:

LOAD *

FROM

[MyFileName.xlsx]

(ooxml, no labels, table is $(TableName));

next index;