Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 .
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 .
perfect , so simple and I couldn't find it myself