topic Data Load thru Xl Sheet in QlikView

Data Load thru Xl Sheet

Wed, 10 Mar 2010 12:52:48 GMT

Hi Team,

I have around 300 xl sheets with below format:

Table 1
Sno	Fld1	Fld2	Fld3	Fld4





Table 2
Sno	Fld1	Fld2	Fld3






Table 3
Sno	Fld1	Fld2	Fld3	Fld4

Every excel sheet contains 3 tables and i have to load data from Table 2 ONLY.

Ideally I have to modify every xl sheet such that there shd be only Table 2 with columns at first row and data in next rows. This requires a lot of manual work & that too for 300 sheets...a tedious & time consuming job.

Is there any way to load data without doing any modification in xl sheets..like i cud be able to define the range in excel sheet for data load?

No of columns and rows will remain fix..ie xl data range will remain same in all xl sheets.

Pls suggest!!

Data Load thru Xl Sheet

Tue, 06 Apr 2010 07:58:21 GMT

Awaiting response please...

Data Load thru Xl Sheet

sparur — Tue, 06 Apr 2010 08:24:14 GMT

Hello. Arun.

I think that standard Table File Wizard can must help you.

I try to create a small example with one Excel file. see in attachment. I think it will help you.

Data Load thru Xl Sheet

Tue, 06 Apr 2010 09:33:46 GMT

Thats really great...

Thanks a lot for your reply.

Data Load thru Xl Sheet

sparur — Tue, 06 Apr 2010 09:38:55 GMT

I very glad to help you :).