Dta loading from different sheets

[nevilledhamsiri]

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

[Anil_Babu_Samineni]

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..

[mdmukramali]

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

[Frank_Hartmann]

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

you could try attached solution

hope this helps

[nevilledhamsiri]

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

[Anil_Babu_Samineni]

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..

[nevilledhamsiri]

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

[Anil_Babu_Samineni · Accepted solution]

Not sure, why not for you?

PFA the excels and code is same

Qlikview I got like below