topic Re: Multiple data tables on one Excel Sheet in QlikView

Multiple data tables on one Excel Sheet

NielBerg — Tue, 12 Mar 2019 16:18:19 GMT

Hi Guys,

Really need your help with the following:

I have an Excel sheet that contains multiple tables per division. The tables for each division vary in size in terms of the number of rows. The columns are however consistent throughout.

In column A, a division's name appears followed by the column headings starting in column B in the next row. I need to write a script to consolidate the data from all tables (divisions) without having to manually manipulate the Excel file.

I am totally stumped and would appreciate any help I can find. I've attached an example of the file with dummy data.

Hope you can help me.

Cheers,

Niel

Re: Multiple data tables on one Excel Sheet

trdandamudi — Wed, 13 Mar 2019 00:48:57 GMT

Please see the attached file and this is one way of doing. I just loaded one file and hope this is what you want.

Re: Multiple data tables on one Excel Sheet

NielBerg — Wed, 13 Mar 2019 04:58:02 GMT

Dear Trdandamudi,

This is exactly what I was looking for.

Thank you so much for your kind assistance.

I really appreciate it.

Regards,

Re: Multiple data tables on one Excel Sheet

trdandamudi — Wed, 13 Mar 2019 08:35:44 GMT

You are welcome and good to know that it helped.