Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 10 Excels with different names.Now i want to create a field "Name" in the table, automatically which should pull the file name into it, with corresponding to its data.
How can i do this?
Regards
KC
Hi,
USe
FilebaseName() as Name
FilebaseName() return FileName
Regards
Hi,
USe
FilebaseName() as Name
FilebaseName() return FileName
Regards
LOAD FileName() As Name,
A,
B
FROM
[ExcelFile.xls]
(ooxml, embedded labels, table is Sheet1);
Load
....
Filename() as myFileName
From
...
Let me know
Thanks a lot everyone