Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to know whether we have a solution to load data from excel if the name of the excel file is maintained on version wise eg.
data_V1.xlsx
data_V2.xlsx
version number will keeps on increasing every month when the data get extracted but file name will be like, data_V3.xlsx, data_V4.xlsx.
I want to keep into sense all the data field. Not only the last.
Regards
You can, Perhaps
Load * From [lib://Connection_Name/data_V*.xlsx];
You can, Perhaps
Load * From [lib://Connection_Name/data_V*.xlsx];