topic Re: Dta loading from different sheets in QlikView

Dta loading from different sheets

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

The steps given here once applied error comes as script line error. Will some one correct me where I am wrong as per the excel given below.

FOR i = 0 to 3

LOAD [BRANCH]

[ PROFITS ]

FROM

[excel files\dummy_excel.xlsx]

(ooxml, embedded labels, table is $(i));

NEXT i

regards

Pradosh

SHEET-A
BRANCH	PROFITS
RA	500
RA1	250
RA3	350

SHEET-B
BRANCH	PROFITS
EM	500
EM1	250
EM2	350

SHEET-C
BRANCH	PROFITS
KW	500
KW1	250
KW2	350

Re: Dta loading from different sheets

Anil_Babu_Samineni — Sun, 24 Sep 2017 06:03:01 GMT

May be this?

FOR i = 0 to 3

LOAD [BRANCH]

[ PROFITS ]

FROM

[excel files\dummy_excel.xlsx]

(ooxml, embedded labels, table is [sheet$(i)]);

NEXT i

Note - sheet means your default sheet names. If you have 1,2,3... normally $(i) should work..

Re: Dta loading from different sheets

mdmukramali — Sun, 24 Sep 2017 07:54:14 GMT

Dear,

You can Try Anil Solution.

and also you can try the below solution if you have static Sheet Tab names:

FOR Each vSheetNames IN 'SHEET-A','SHEET-B','SHEET-C'

LOAD [BRANCH]

[ PROFITS ]

FROM

[excel files\dummy_excel.xlsx]

(ooxml, embedded labels, table is [$(vSheetNames)];

NEXT

Thanks,

Mukram

Re: Dta loading from different sheets

Frank_Hartmann — Sun, 24 Sep 2017 08:34:37 GMT

If you have sheetnames in excel without any structure (e.g Sales, Country, Expense,.....)

you could try attached solution

hope this helps

Re: Dta loading from different sheets

nevilledhamsiri — Sun, 24 Sep 2017 09:26:49 GMT

Hi, Anil,

Once I loaded the data as follows, an error comes as "script line error" please check where I am wrong. Dear Mohomed, Your solution did work. Thanks

FOR i= A to C

LOAD BRANCH,

PROFITS

FROM

[..\DIFFERENT SHEETS.xlsx]

(ooxml, embedded labels, table is $(A));

NEXT i

Re: Dta loading from different sheets

Anil_Babu_Samineni — Sun, 24 Sep 2017 10:16:38 GMT

In my way, variable should be allocate to sheet numbers because variable can create automate passing loops.

Not sure, how your sheet names looks like..

Re: Dta loading from different sheets

nevilledhamsiri — Sun, 24 Sep 2017 10:38:52 GMT

Dear Anil,

See the data in excel, I have given what is in three sheets which are in same field headers. If that is the case, is it wrong the way I have loaded the data?

Neville.

You may if possible write it in the script for the data to be loaded which are in three sheets

Re: Dta loading from different sheets

Anil_Babu_Samineni — Sun, 24 Sep 2017 11:56:26 GMT

Not sure, why not for you?

PFA the excels and code is same

Qlikview I got like below