Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi! Use wildcard when loading the data as follows:
FROM [lib://Data/*.xlsx]