topic Re: Loading Multiple sheets from one excel file in QlikView

Loading Multiple sheets from one excel file

bhavvibudagam — Sat, 16 Apr 2016 07:15:33 GMT

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,

Re: Loading Multiple sheets from one excel file

qlikview979 — Sat, 16 Apr 2016 07:19:23 GMT

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;

Re: Loading Multiple sheets from one excel file

qlikview979 — Sat, 16 Apr 2016 07:21:14 GMT

Hi Bhavvi,

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

Re: Loading Multiple sheets from one excel file

bhavvibudagam — Sat, 16 Apr 2016 07:32:55 GMT

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.

Re: Loading Multiple sheets from one excel file

Sat, 16 Apr 2016 09:07:39 GMT

Hi Bhavvi,

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

Regards,

Mahesh