Loading Multiple sheets from one excel file

[bhavvibudagam]

Hi,

   can any please help me.I have added one Excel file and QVW FIle.Please find below.

In an Excel file i have different sheets as 100389,100462,700123,700156.all these files have same filed names i have to concatenate the data form all the sheets.

    Please help me to do this. And i am getting one error i.e "cant locate table in Biff file" .I have tried some logic in Qlik view please find the QVW file .And the loop has to be repeated for only particular sheets didn't consider the sheets in between 100389 to 100462.

Thanks,

[qlikview979]

Hi Bhavvi,

Try like this

for each vpeek in '100389$','100478$','700891$','701842$';

T1:

LOAD [Call ID],

     Region,

     STATE,

     Format1,

     Format2,

     call1,

     call2,

     call11,

     call21

FROM

(biff, embedded labels, header is 1 lines, table is [$(vpeek)]);

NEXT vpeek;

[qlikview979]

Hi Bhavvi,

if u get same error ..Try to change ur excel sheet from .xsl to .xlsx format

[bhavvibudagam]

Hi mahesh,

      Thank you for your response.But in future their is a chance to add more sheets in this file.So the requirement is concatenate the data in all sheets dynamically.

[#5]

Hi Bhavvi,

if u add   'N' number of sheets it will work

Regards,

Mahesh