Dealing with Monthly Recurring sheets with same columns?

[anurag644]

I have multiple technologies in which there are multiple reports generated under each technology every month/quarterly, how do I combine them and also have the previous months data.

Example:

1.Compute (Logically separated Technology)

a.ABC.xls (excel sheet report)

b.DEF.xls (excel sheet report)

.

.

2.Network (Logically separated Technology)

a.XYZ.xls (excel sheet report)

b.UVW.xls (excel sheet report)

all reports have the same columns names.

Your solutions are highly appreciated.

Thanks in advance.

[Ivan_Bozov]

Hi! Use wildcard when loading the data as follows:

FROM [lib://Data/*.xlsx]