Looping through excel sheets and combining 2 different workbooks

[#1]

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

[#2]

Concatenate the two files using Concatenate function like below:

Data:

LOAD * from File1.tab1;

Concatenate(Data)

Load * from File1.tab2;

[#3]

Hi Dathu,

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

Thanks,

Deepti

[jonas_rezende · Accepted solution]

Hi, dgopalareddy04.

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

Regards,

Jonas Melo.

[#5]

Hello Jonas,

Thanks much for your help.!

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

[#6]

Thanks Jonas. I was able to open the file.

Appreciate your help...!!