topic Re: One LOAD statement from two sheets in same Excel Workbook in QlikView

One LOAD statement from two sheets in same Excel Workbook

Wed, 12 Nov 2014 11:06:03 GMT

Hi,

I'm trying to figure out how to load data (with the same format and headers) from two tabs in Excel, "Incoming" and "Outgoing".

Can I state the two sheets in the FROM statement maybe?

Any ideas?

Kind Regards,

Olle

Re: One LOAD statement from two sheets in same Excel Workbook

alexandros17 — Wed, 12 Nov 2014 11:13:39 GMT

You must load them one by one with 2 loads or in a for next loop

Re: One LOAD statement from two sheets in same Excel Workbook

alkesh_sharma — Wed, 12 Nov 2014 11:22:18 GMT

IF your sheet name is sheet1 and sheet2 (Numerically Ascending), you can achieve it using loop. but if the sheets have completely independent name like 'East' and 'West' then you have to load them separately.

Re: One LOAD statement from two sheets in same Excel Workbook

Anonymous — Wed, 12 Nov 2014 11:41:13 GMT

Hi Olle,

If you are using the Table Files... wizard to import data then you need to use the "Tables" drop down on the first screen of the wizard to select which sheet to import.

If the fields are identical between sheets then you can copy an existing load statement and change the sheet name manually (find the "table is @tablename").

If you have multiple identical sheets, or sheets are dynamically added then a loop might become more efficient, but this can be more complex to set up.

Re: One LOAD statement from two sheets in same Excel Workbook

Aurelien_Martinez — Wed, 12 Nov 2014 13:21:32 GMT

Hi,

You can do a for each loop like

for each vSheet in 'Incoming', 'Outgoing'

MY_TABLE

LOAD

FROM XL.xls (biff, embedded labels, table is [$(vSheet)])

;

NEXT vSheet

(I think that work )

Aurélien

Re: One LOAD statement from two sheets in same Excel Workbook

Thu, 13 Nov 2014 10:13:15 GMT

Perfect! Thanks a lot.

Works like a charm. A bit slower than two separate LOADS for som reason but works great for my purpose.

Kind Regards,

Olle