topic Re: Loading in QlikView

Loading

Mon, 17 Jun 2013 05:37:00 GMT

How can I load multiple Excel sheet in single load statement?????

sujeetsingh — Mon, 17 Jun 2013 05:51:19 GMT

no you have to give load statement for each file

kumarnatarajan — Mon, 17 Jun 2013 05:59:07 GMT

Hi,

Refer this url.It's very helpful for you

Mon, 17 Jun 2013 06:08:58 GMT

FOR Each vSheet in 'Sheet1','Sheet2','Sheet3'

Table:

load *

from D:\book2.xlsx (00xml,embedded labels, table is $(vSheet));

next vSheet;