Max Table name

[Sameer9585]

Hi,

I have situation where it is that there are few table names date wise and I need to get the data of max table name.

Means if I had table names as Sales_1/1/2019,Sales_2/1/2019,Sales_3/1/2019,Sales_4/1/2019...now I need a script in that a way that to give it should display tables Sales_4/1/2019 which is the max one in this.

Thanking You in advance,

[PrashantSangle · Accepted solution]

if all files in same location then try below code
Set $(vexcelpath)='c:\docuement\';

FileName:
First 1
LOAD SubField(FileBaseName(),'_',2) as fileName
FROM [lib://$(vexcelpath)\*.xlsx]
(ooxml, embedded labels, table is Sheet1);

maxDateFile:
Load max(fileName) as maxDate Resident FileName;

Let vMaxFileName = Peek('maxDate',0,'maxDateFile');

Final_Load:
Load * from FROM [lib://$(vexcelpath)\Sale_$(vMaxFileName).xlsx]
(ooxml, embedded labels, table is Sheet1);

Regards,
Prashant Sangle