load multiple Excel in one table + Excel name in a column

[#1]

I have a few excel files which I load into QV like this

table1:

Load

     field1

     field2 ...

from C:\file*.xlsx (ooxml, embedded labels, table is Part1);

That's working fine, but now I want to add another coloumn/field to my table1 which contains the excelfile name and another field which contains the spreadsheet name.

How can I change my script to add the file name and the name of the spreadsheet into the table?

[rajni_batra · Accepted solution]

table1:

Load

     field1,

     field2 ,

Filename() ...

from C:\file*.xlsx

Filename function returns u the name of the file u r loading. u can check wid this .

[#3]

perfect , so simple and I couldn't find it myself