Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
What is the best practice for getting the new column that includes excel file name from which the data was loaded?
Now my script looks like this:
LOAD %Point
,ID
FROM
(ooxml, embedded labels, table is Sheet1);
Lets say I have 2 files: A.xlsx and B.xlsx
Thank you!
You could simply add filename() as Source or filebasename() as Filename within your load-statement.
- Marcus
You could simply add filename() as Source or filebasename() as Filename within your load-statement.
- Marcus
That's what I needed!