topic How to load data from different excel sheet tabs? in QlikView

How to load data from different excel sheet tabs?

Tue, 12 May 2015 12:19:10 GMT

Hi everyone,

Can anyone help me with this challenge.

I have an excel file which has two sheet tabs, the first sheet tab has two columns(A and B), and the second one has three columns(C, D, and E).

At the end I would like to have a table with both columns from the first sheet and one column from the second sheet.

A	B
a	i
b	f

First sheet tab

C	D	E
1	x	r
2	y	s

Second sheet tab

At the end I need such a table:

C	A	B
1	a	i
2	b	f

How can I load data from those two sheet tabs to achieve that?

Thanks ahead!!

Regards,

Olivier

Re: How to load data from different excel sheet tabs?

awhitfield — Tue, 12 May 2015 15:29:40 GMT

Hi Oliver,

See below:

Data1:
LOAD A,
B
FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate
LOAD C
FROM

(ooxml, embedded labels, table is Sheet2);

Andy

Re: How to load data from different excel sheet tabs?

awhitfield — Tue, 12 May 2015 15:32:47 GMT

PS - please don't duplicate posts on the Community:https://community.qlik.com/thread/163675