topic Re: Looping through excel sheets and combining 2 different workbooks in QlikView

Looping through excel sheets and combining 2 different workbooks

Thu, 20 Aug 2015 19:56:38 GMT

Hello All,

I have 2 Excel workbooks. Each workbook has data for different years in different sheets.

The format (or columns) remain same for all sheets within the workbook. the 2 workbooks carry some common fields between them.

Please see the attached sample workbooks.

The requirement is to pull all sheets data from one workbook and combine it on common fields with data coming from other workbook.

I appreciate you all taking some time out and helping me out here.!!

Thanks much,

Deepti

Thu, 20 Aug 2015 20:03:58 GMT

Concatenate the two files using Concatenate function like below:

Data:

LOAD * from File1.tab1;

Concatenate(Data)

Load * from File1.tab2;

Thu, 20 Aug 2015 20:09:20 GMT

Hi Dathu,

can you please tell me how to loop through each workbook before concatenating the two files.

Thanks,

Deepti

jonas_rezende — Thu, 20 Aug 2015 21:27:49 GMT

Hi, dgopalareddy04.

See if qvw helps! Otherwise, hope give a good idea for you.

Regards,

Jonas Melo.

Thu, 20 Aug 2015 21:35:05 GMT

Hello Jonas,

Thanks much for your help.!

I am unable to open the attachment. Could you please upload once again.

Thu, 20 Aug 2015 21:46:07 GMT

Thanks Jonas. I was able to open the file.

Appreciate your help...!!