topic Re: How to pull data from multiple Excel files? in QlikView

How to pull data from multiple Excel files?

chiranjivdas — Thu, 17 Jan 2013 02:23:23 GMT

I have a QV file that currently pulls data from one excel file and the script is as follows:

LOAD Name,

Height,

Weight

FROM
[Height-Weight.xlsx]
(ooxml, embedded labels);

I want it to pull additional data from a separate excel file called Track Record in the same folder. How do I change the script and make this happen?

Attached are the excel files and the QV file.

Thanks,

Re: How to pull data from multiple Excel files?

Thu, 17 Jan 2013 07:05:03 GMT

Hi Buddy,

Following is the simple short code for your query

Height_Weight:

LOAD Name,

Height,

Weight

FROM

[..\Desktop\Gaurav\Height-Weight.xlsx]

(ooxml, embedded labels, table is Sheet1);

Track_Record:

LOAD Name,

[Current Timing],

[Best Timing]

FROM

[..\Desktop\Gaurav\Track Record.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: How to pull data from multiple Excel files?

Thu, 17 Jan 2013 07:06:46 GMT

Hi,

PFA sample application

Regards

Gaurav

Re: How to pull data from multiple Excel files?

Thu, 17 Jan 2013 07:15:39 GMT

Hi,

You can directly load the second table just like you've loaded the first one.

Since both the tables have a common field (Name, in this case), QlikView will automatically link these fields to form a key enabling your data set to look like a single connected table.

Your script should look like this:

HeightWeightTable:

LOAD Name,

Height,

Weight

FROM

[Height-Weight.xlsx]

(ooxml, embedded labels);

TrackRecordTable:

LOAD Name,

[Current Timing],

[Best Timing]

FROM

[Track Record.xlsx]

(ooxml, embedded labels, table is Sheet1);

Please check the attachment.

In scenarios where the data is same but field names are different for two tables, you can alias one of the fields from either of the tables to form a link between them.

Hope that helps.

Regards,

-Khaled.

Re: How to pull data from multiple Excel files?

chiranjivdas — Thu, 17 Jan 2013 17:51:02 GMT

Thank you, people. All answers were very helpful.